Jump to content

Archived

This topic is now archived and is closed to further replies.

baber_abbasi

LEFT JOIN

Recommended Posts

I have edited an existing code to my own having LEFT JOIN feature in it. I am getting errors while replacing table name.

 

EXISTING CODE

$tablepre = \"calendar\";

$sql = \"SELECT id, y, m, d, title, text, TIME_FORMAT(start_time, \'%l:%i %p\') AS stime, TIME_FORMAT(end_time, \'%l:%i %p\') AS etime, \" . $tablepre . \"users.uid, fname, lname FROM \" . $tablepre . \"mssgs LEFT JOIN \" . $tablepre . \"users ON (\" . $tablepre . \"mssgs.uid=\" . $tablepre . \"users.uid) WHERE id = \" . $id;

 

I need to replace [ \" . $tablepre . \"users.uid ] with [ clients.uid ]

 

Thankx in advance.

Share this post


Link to post
Share on other sites

It\'s alot easier to use aliases for table names when joining tables. That way you only have one occurence of each tablename

 

eg (partial query as sample)

 

SELECT a.id, a.y, a.m, a.d, a.title, b.name

FROM calendarmssgs a INNER JOIN calendarusers b

ON a.uid = b.uid

WHERE a.id = $id

 

hth

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.