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
IL PROTECTED]>
Sent: Saturday, November 23, 2002 4:14 AM
Subject: select from two table
> I have 2 table with same structure
>
> table 1 have name and position
> table 2 have name and position
>
> name in table 1 same as name in table 2 but position in table 1 may not
> s
Omar" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, November 22, 2002 11:14 PM
Subject: select from two table
> I have 2 table with same structure
>
> table 1 have name and position
> table 2 have name and position
>
> name in table 1 s
I have 2 table with same structure
table 1 have name and position
table 2 have name and position
name in table 1 same as name in table 2 but position in table 1 may not
same as position in table 2
how do I get data like this
what is sql command
nameposition.table1 position.table2
tha