Martin Zvarík wrote:
This will work:
$sql = "
SELECT admin.AdminID, workorders.WHAT_YOU_WANT
INNER JOIN workorders ON admin.AdminID=workorders.AdminID
Don't use having in this case - this should be a 'where' clause.
A 'having' clause is processed AFTER everything else (after where, after
joins, after aggregate's are calculated like sum/max/min), using it like
this will cause performance issues where you shouldn't have any.
Postgresql & php tutorials
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php