re: joing 2 columns to 1 table

2002-12-06 Thread Egor Egorov
Rich, Friday, December 06, 2002, 2:23:49 AM, you wrote: RA if i have the following mySQL tables RA create table list ( RA id int, RA name char(20) RA ); RA insert into list values(1, 'bob'); RA insert into list values(2, 'joe'); RA create table list2 ( RA id1 int, RA id2 int RA ); RA insert

Re: joing 2 columns to 1 table

2002-12-06 Thread Roger Baklund
* Rich Allen if i have the following mySQL tables create table list ( id int, name char(20) ); insert into list values(1, 'bob'); insert into list values(2, 'joe'); create table list2 ( id1 int, id2 int ); insert into list2 values(1,2); insert into list2 values(2,1); what

joing 2 columns to 1 table

2002-12-05 Thread Rich Allen
if i have the following mySQL tables create table list ( id int, name char(20) ); insert into list values(1, 'bob'); insert into list values(2, 'joe'); create table list2 ( id1 int, id2 int ); insert into list2 values(1,2); insert into list2 values(2,1); what query will return the following