Jump to content
Larry Ullman's Book Forums

Select/Inner Join Problerm


Recommended Posts

mysql:5.0.91

php:5.2.12

 

SELECT CONCAT(masterpx.mpx_lname, ', ', masterpx.mpx_fname) AS name, DATE_FORMAT(inpx_admission.inpx_admission_date, '%M %d, %Y') AS indate FROM masterpx INNER JOIN inpx_admission ON masterpx.mpx_id=inpx_admission.mpx_idfk AND inpx_admission.admission_status = 'admitted' ORDER BY masterpx.mpx_lname

 

help pls..when i use these query i receive this error message:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result

Unknown column 'inpx_admission.admission_status' in 'on clause'

Link to comment
Share on other sites

 Share

×
×
  • Create New...