Re: Help with SQL Queries

Hi, I'm including your post to the forum as well. The problem I think is the fact that you need to do LEFT JOIN in two directions which quite often don't turn out what you want. So what you can do is to do two queries, UNION them together and form a derived table that you then do your final SELECT

Re: Help with SQL Queries

hey thx for the reply.. here's my query.. http://forums.mysql.com/read.php?20,119150,119150#msg-119150 thx. yashesh bhatia. On 10/4/06, Rob Desbois <[EMAIL PROTECTED]> wrote: Yes, ask away :) > Hi, Is the the right group to post for questions with SQL Queries ? thx. yashesh bhatia --

re: Help with SQL Queries

Yes, ask away :) > Hi, Is the the right group to post for questions with SQL Queries ? thx. yashesh bhatia -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _