Jocelyn
> - Original Message -
> From: "Dennis Salguero" <[EMAIL PROTECTED]>
> To: "Osman Omar" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
> Sent: Saturday, November 23, 2002 1:21 AM
> Subject: Re: select from two table
&g
>
To: "Dennis Salguero" <[EMAIL PROTECTED]>; "Osman Omar"
<[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Saturday, November 23, 2002 11:28 PM
Subject: Re: select from two table
> don't forget
>
> FROM table1,table2 ;)
> :
>
To: "Dennis Salguero" <[EMAIL PROTECTED]>; "Osman Omar"
<[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Saturday, November 23, 2002 11:28 PM
Subject: Re: select from two table
> don't forget
>
> FROM table1,table2 ;)
> :
ECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Saturday, November 23, 2002 1:21 AM
Subject: Re: select from two table
> You might want to add some unique IDs or something else in common to make
> this query a bit better, but the following is what you should be doing:
>
>
&g
Hi,
Try :
SELECT table1.name,table1.position,table2.position FROM table1 LEFT JOIN
table2 USING(name);
Take a look here :
http://www.mysql.com/doc/en/JOIN.html
Regards,
Jocelyn
- Original Message -
From: "Osman Omar" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Saturday,
You might want to add some unique IDs or something else in common to make
this query a bit better, but the following is what you should be doing:
SELECT name, table1.position, table2.position
WHERE table1.name=table2.name
Good Luck!
Dennis
- Original Message -
From: "Osman Omar" <[EMAI
