0

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.

2
Contributors
1
Reply
2
Views
10 Years
Discussion Span
Last Post by extofer
0

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??

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.