Re: Re: Problems with INNER JOIN

Actually I have tried EVERYTHING suggested and it just does not work, in my last query here I put in a user I know has orders and still nothing : $sql3 = "SELECT admin.AdminID, workorders.WorkOrderID, workorders.DATE_FORMAT(CreatedDate,'%m/%e/%y') AS SubmitDate, workorders.Location, workorders.AdminID, workorders.FormName, workorders.Status FROM admin INNER JOIN workorders ON admin.AdminID = workorders.AdminID WHERE admin.username = 'lhanford' "; Are there mySQL settings that could prevent JOINS? On Thu, Jan 29, 2009 at 3:44 PM, Chris <dmagick@gmail.com> wrote: > 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/ > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >