Is there a shorter version of this query?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 403,516 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,867 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 217 | Replies: 0

•

Join Date: Jul 2008

Posts: 33

Reputation: jakesee is an unknown quantity at this point

Rep Power: 1

Solved Threads: 1

jakesee

Offline

Light Poster

Is there a shorter version of this query?

Jul 16th, 2008

Hi,

I don't know what is LEFT JOIN at all, but i accidentally made this query work. Can someone tell me if there is a shorter version of this query?

 Help with Code Tags 
 SQL Syntax (Toggle Plain Text) 
SELECT j . * , k.report
FROM (
 SELECT x . * , y.category AS parent_category
 FROM AccountCategories x
 LEFT JOIN AccountCategories y ON x.parent_category_id = y.category_id
) j
LEFT JOIN AccountReports k ON j.report_id = k.report_id
SELECT j . * , k.report
FROM (
 SELECT x . * , y.category AS parent_category
 FROM AccountCategories x
 LEFT JOIN AccountCategories y ON x.parent_category_id = y.category_id
) j
LEFT JOIN AccountReports k ON j.report_id = k.report_id

If possible, would you show me what is the meaning of LEFT JOIN, RIGHT JOIN, INNER JOIN and OUTER JOIN? I've read alot of tutorials but I can only understand CROSS JOIN so far.