|
| |
|
Cannot find staff info! SELECT staff.first, staff.last, staff.profCopy, staff.position, home.name, rel_file.rlf_name FROM staff, home LEFT JOIN rel_file ON staff.id = rel_file.stf_id WHERE staff.home_id = home.id AND staff.status = 'active' AND staff.profStatus = 'active' ORDER BY staff.home_id, staff.position
|