>Dude, I AM going to be inserting data!
Yeah, I know. And I said below, in effect, "so what"?
I'm still waiting for an answer what that has to do with
anything. When you insert, you insert back into the
original table, not the merge table. So what's the
>- Deryck H
>----- Original Message -----
>From: "Paul DuBois" <paul@stripped>
>To: "Deryck Henson" <ussj4gohan@stripped>; <lgoodbar@stripped>
>Cc: "MySQL" <mysql@stripped>
>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
>> >my tables are EXACTLY the same. All I want to do is take the records
>> >all 15 of the tables where the username(column) in them is what I say.
>> >I try to do this, it gives me an error that says it's ambiguous. So I
>> >to merge all the tables (and I dont mean the MERGE statement) together to
>> Actually, you probably do want a MERGE statement. Or rather, a MERGE
>> table. Your reason for not using one is that it doesn't support INSERT.
>> I asked what that had to do with anything, because when you want to update
>> one of these fifteen tables, you'll clearly want to put the row back in
>> the table from which it originally came, and therefore must know which
>> table that is. (If you don't know, that means you can't distinguish them
>> and then there's no reason to have 15 tables in the first place.) I'm
>> still unclear why a MERGE table won't work. LEFT JOIN isn't what you
>> >create a sort of one big master table but it still knows what table each
>> >record is from. Hopefully that clears things up a bit, and I do
>> >appreciate that long yet excellent explanation on LEFT JOINS. Thank you
>> >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" <lgoodbar@stripped>
>> >To: "Deryck Henson" <ussj4gohan@stripped>
>> >Sent: Thursday, September 13, 2001 6:13 PM
> > >Subject: Re: using LEFT JOINS
> > >
Paul DuBois, paul@stripped