..joining 2 tables?=A tuf one....can U crack this ?

[jaay]

Listen, I 've 2 tables of the following nature :

Table 1
---------

col1 | col2 | col3 |
--------------------------------------------------------
1 name1 xxxxxxxxxx
1 name1 ssssssssssss
1 name1 rrrrrrrrrrrrrr
2 name1 qqqqqqqqqq
2 name1 eeeeeeeeee

and so on........


Table 2
=======

col1 | col2 | col3
------------------------------------------------------
1 name1 1111111111
2 name1 2222222222

Now , I would like to join these 2 tables.....

What kind of a record selection formula do I write ???


Any help.......is welcome.....

Bye.

[extofer]

SELECT * FROM Table1 INNER JOIN Table2 on TABLE1.col1 = TABLE2.col2

* will selct all fields, if you want certain fields, do TABLE1.col1, TABLE2.col2

Does this Help??