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.