[Resolved] Join statement on 2 tables that share field names

[adrianpeyton]

Hi, I am using a join statement between 2 tables that share some fieldnames.
id, added_date

My current query is below, but this prints out the users.id ahead of the Request id.

$query = "SELECT * FROM Request LEFT JOIN users ON users.id = Request.initiator 
AND Request.status =\"Open\" ORDER BY users.fullname ASC";

Then I access the results by the following

 
$display_result=mysql_db_query("$db", $query);

while ($rec = mysql_fetch_array($display_result)) 
{
       $temp1 = $rec["id"];
}

And it prints out the users.id instead of the Request ID.
I only need to view users.fullname, but I need all the fields from the Request table.

What can I do to find the proper one ?

[mtmosier]

$query = "SELECT users.fullname, Request.* FROM Request LEFT JOIN users ON users.id = Request.initiator AND Request.status =\"Open\" ORDER BY users.fullname ASC";

[adrianpeyton]

Thanks mtmosier,

That nearly worked. It did not seem to execute the where clause properly.

I had an "AND" instead of a "WHERE" in the statement.

The following query executed perfectly

$query = "SELECT users.fullname, Request.* FROM Request LEFT JOIN users ON users.id = Request.initiator [B]WHERE[/B] Request.status =\"Open\" ORDER BY users.fullname ASC";