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>

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)