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
| ID |
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 Values and NONE
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 tables:
Table A
| ID
[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
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
Subject: Re: Im being dumb!
Ack
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
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 |
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 | Description2 |
Table C
|