On 3/6/08 12:09 PM, "Tim McDaniel" <[EMAIL PROTECTED]> wrote:
> On Thu, 6 Mar 2008, Dan Rogart <[EMAIL PROTECTED]> wrote:
>> On 3/6/08 8:33 AM, "roger.maynard" <[EMAIL PROTECTED]> wrote:
>>> I got 4 tables:
>>>
>>> Table A
>>> | ID | Description1 |
>>>
>>> Table B
>>> | ID | De
On Thu, 6 Mar 2008, Dan Rogart <[EMAIL PROTECTED]> wrote:
On 3/6/08 8:33 AM, "roger.maynard" <[EMAIL PROTECTED]> wrote:
I got 4 tables:
Table A
| ID | Description1 |
Table B
| ID | Description2 |
Table C
| ID | Description3 |
Table D
| ID | Description4
Thanks guys!! << gone to chase some of Dan's coffee >>
Brain gone.. and too many remnants of FoxPro SQL with "INNER JOINS"
Rog
-Original Message-
From: Dan Rogart [mailto:[EMAIL PROTECTED]
Sent: 06 March 2008 13:53
To: Dan Rogart; roger.maynard; mysql list
Ack, listen to Nanni not me. Join order doesn't matter, now that I tested
some more :).
Off to drink more coffee,
Dan
On 3/6/08 8:45 AM, "Dan Rogart" <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
> On 3/6/08 8:33 AM, "roger.maynard" <[EMAIL PROTECTED]> wrote:
>
>> I got 4 tables:
>>
>> Table A
>> |
[snip]
-Original Message-
From: roger.maynard [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2008 7:33 AM
To: mysql@lists.mysql.com
Subject: Im being dumb!
I got 4 tables:
Table A
| ID | Description1 |
Table B
| ID | Description2 |
Table C
| ID
Hi Roger,
That is ok, just try to substitute 'INNER' with 'LEFT'
Aloha!
Claudio Nanni
-Messaggio originale-
Da: roger.maynard [mailto:[EMAIL PROTECTED]
Inviato: giovedì 6 marzo 2008 14.33
A: mysql@lists.mysql.com
Oggetto: Im being dumb!
I got 4 t
Hi,
On 3/6/08 8:33 AM, "roger.maynard" <[EMAIL PROTECTED]> wrote:
> I got 4 tables:
>
> Table A
> | ID | Description1 |
>
> Table B
> | ID | Description2 |
>
> Table C
> | ID | Description3 |
>
> Table D
> | ID | Description4 |
>
> ALL Ids ARE COMMON
I got 4 tables:
Table A
| ID | Description1 |
Table B
| ID | Description2 |
Table C
| ID | Description3 |
Table D
| ID | Description4 |
ALL Ids ARE COMMON Values and NONE are MISSING
How can I create
| ID | Description 1 | Description 2 | Description 3
