In article <[EMAIL PROTECTED]>, "shaun thornburgh" <[EMAIL PROTECTED]> writes:
> Hi, > Unfortunately that doesnt work, I need to LEFT JOIN Bookings to Weeks > but keep the current join on Projects there as well, any ideas? So what you would need is something like that: Weeks LEFT JOIN (Bookings INNER JOIN Projects) This could be converted to: Bookings INNER JOIN Projects RIGHT JOIN Weeks Unfortunately MySQL's RIGHT JOIN implementation has been broken for ages and won't get fixed until 5.x. Thus your only option is putting the results of the INNER JOIN into a temporary table and then use "Weeks LEFT JOIN temp". -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
