/* Good */ $sql="SELECT host.host_uid, host.host_display, location.location_display FROM host, location WHERE host.location_uid=location.location_uid ORDER BY host.host_display, location.location_display"; /* Bad */ $sql="SELECT host.host_uid,host.host_display,location.location_display FROM host,location WHERE host.location_uid=location.location_uid ORDER BY host.host_display,location.location_display";