a join question

hi all
is there any way to do that;
i have 2 tables
This is table1;
code1 code2 code3
--------- -------- ---------
9 8 7

This is table2;

Code Description

---------    ----------------
9            Nine
8            Eight
7            Seven

So,i just wanna do a query that can get descriptions of all field in table1 from table2 at same time.
i did run that,
select table1.*,table2.* from table1,table2 where table1.code1=table2.code
when i run that i can not get the code2's and code3's description so. how can i do that

thanks for any help Received on Mon Jan 23 2006 - 19:31:27 CST