Re: Problems with INNER JOIN

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']."'
";


Terion Miller napsal(a):
> Hi Everyone! I am having problems getting an INNER JOIN to work and need
> some tips trouble shooting where the problem may be.
> 
> What I'm trying to do is match up AdminID's from two tables and display only
> that users orders, sounds simple enough right...but I can't get it to return
> the AdminID...
> 
> My Query:
> 
>    $sql =
>      "SELECT admin.AdminID , workorders.AdminID
>          FROM admin
>              INNER JOIN
>          workorders ON
>           (admin.AdminID=workorders.AdminID)
>          WHERE admin.UserName =   '".$_SESSION['user']."' ";
> 
> 
>       $result = mysql_query ($sql);
>       $row = mysql_fetch_assoc ($result);
>       $Total = ceil(mysql_num_rows($result)/$PerPage);
> 
> Thanks for any tips on how else I can accomplish this...
> Terion
>