hi, I'm wondering if anyone knows if it's possible to do a double-outer join in mysql. by that I mean outer-joining on two tables instead of one (both from the same original table). in other words, whereas a normal outer join might go something like this:
select b.date, u.name from billing b outer join users u on b.user_id=u.user_id ...I'm trying to do something more like this: select b.date, u.name, l.city from billing b outer join users u on b.user_id = u.user_id, locations l on b.location_id = l.location_id (that syntax is bogus) but does anyone know if this is even possible? thanks, todd --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
