Re: How to use JOINS

2001-09-12 Thread Deryck Henson
MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, September 12, 2001 2:56 AM Subject: Re: How to use JOINS > On Wed, Sep 12, 2001 at 02:13:59AM -0500, Deryck Henson wrote: > > > > OK, well, mysql has LEFT JOINS, right? OK then, in that case, how > > the heck do I use them?! I ne

Re: How to use JOINS

2001-09-12 Thread Jeremy Zawodny
On Wed, Sep 12, 2001 at 02:13:59AM -0500, Deryck Henson wrote: > > OK, well, mysql has LEFT JOINS, right? OK then, in that case, how > the heck do I use them?! I need to join 14 tables (with the exact > same structure, columns) together and view all of there contents > with a WHERE clause like t

How to use JOINS

2001-09-11 Thread Deryck Henson
OK, well, mysql has LEFT JOINS, right? OK then, in that case, how the heck do I use them?! I need to join 14 tables (with the exact same structure, columns) together and view all of there contents with a WHERE clause like this: SELECT * FROM t1, t2, t3, t4, t5, etc ORDER BY date DESC or SELEC