Re: Re: Problems with INNER JOIN

Martin Zvarík wrote:

This will work: $sql = " SELECT admin.AdminID, workorders.WHAT_YOU_WANT FROM admin INNER JOIN workorders ON admin.AdminID=workorders.AdminID HAVING admin.username='".$_SESSION['user']."' ";

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 http://www.designmagick.com/