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
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 the manual cause Ive tried that and it
doesnt give a good enough explanation. This will be very helpful when
d
10 matches
Mail list logo
