TalkPHP - View Single Post

xenon · 12-02-2008, 04:13 PM

Code:

SELECT u.*, b.*, bc.* FROM blog_comment bc LEFT JOIN blog b ON(b.id=bc.blog_id) LEFT JOIN user u ON(u.id=b.user_id)

That will return the result just fine, although it can be optimized.

12-02-2008, 04:13 PM	#2 (permalink)
xenon The Frequenter Join Date: Dec 2007 Location: Bucharest, Romania Posts: 438 Thanks: 3	Code: SELECT u., b., bc.* FROM blog_comment bc LEFT JOIN blog b ON(b.id=bc.blog_id) LEFT JOIN user u ON(u.id=b.user_id) That will return the result just fine, although it can be optimized. __________________ I have optimistic thoughts, even though sometimes (if not always) life's a bitch.