e, level enum ('all', 'novice', 'intermediate', 'advanced')
>
> - Deryck H
> - http://www.comp-u-exchange.com
> - Original Message -
> From: "Gerald Clark" <[EMAIL PROTECTED]>
> To: "Deryck Henson" <[E
CTED]>
Sent: Thursday, September 13, 2001 10:22 PM
Subject: Re: using LEFT JOINS
Duh on me... what about this (may not work with MySQL, does it support
unions
yet?)
insert into mastertable (user,name,info)
(select * from one where user='loyd'
union
select * from two where user=&
Duh on me... what about this (may not work with MySQL, does it support unions
yet?)
insert into mastertable (user,name,info)
(select * from one where user='loyd'
union
select * from two where user='loyd'
union
...)
repeat to table 15. Since 15 tables have the same structure, this will work.
ot;Gerald Clark" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 10:00 AM
Subject: Re: using LEFT JOINS
> Show us your table definitions, what you tried, and
> what you think
>
>- Deryck H
>- http://www.comp-u-exchange.com
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Deryck Henson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Cc: "MySQL" <[EMAIL PROTECTED]>
>Sent:
gt;
Sent: Thursday, September 13, 2001 8:04 PM
Subject: Re: using LEFT JOINS
> At 7:55 PM -0500 9/13/01, Deryck Henson wrote:
> >OK, first of all, brilliant and well thought out. One problem, every one
of
> >my tables are EXACTLY the same. All I want to do is take the records
from
" <[EMAIL PROTECTED]>
>To: "Deryck Henson" <[EMAIL PROTECTED]>
>Sent: Thursday, September 13, 2001 6:13 PM
>Subject: Re: using LEFT JOINS
>
>
>On Thu, 13 Sep 2001 07:03:03 -0500, "Deryck Henson" <[EMAIL PROTECTED]>
>wrote:
>
u and
please, if you have an idea of what I mean, please tell me an answer.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Loyd Goodbar" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001
Show us your table definitions, what you tried, and
what you think didn't work.
Deryck Henson wrote:
> Well, before I asked which joins to use and now I want to know how to use
> the LEFT JOINS. They would be quite useful on my site right now. Any help
> is appreaciated and dont say to read
