Dawn H ([EMAIL PROTECTED]) writes:
> I have four tables, and I want to use bits of each one to display a list on
> one page. I tried listing what I wanted out of each, but it seems that if
> any one of the fields chosen is null, the whole row with that ID# is left
> out. I thought perhaps a LEFT JOIN but don't know how to make that work on
> four tables rather than just two.
Can you give us an example?
By the way, I use Access a lot to build and model complex queries - I use linked
tables via MyODBC, and I play with it until I get it right, then hack Microsoft's idea
of SQL until the syntax is right, then feed it to MySQL. Works like a charm. :)
You might want to try the same thing with your query.
--
Ed Carp, N7EKG [EMAIL PROTECTED] 214/986-5870 cell phone
http://www.pobox.com/~erc
I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.
---------------------------------------------------------------------
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