Joining fields in two table together.

[michelle]

Dear VB programmers,


Can someone please tell me the syntax to join two tables:

In database "C:\Q.MDB"

Content of Q.MDB:

Tables Fields
Cities Street
Town

Names Street
NickName

Source:

Dim DBS As Database
Dim RS As Recordset

Set DBS = OpenDatabase("c:\q.mdb")
Set RS = DBS.OpenRecordset("???????????????")

What do I have to fill in on the quetion marks if I want to join Cities.street with Names.street?

Nice greetings,

Michelle.

[bsmith]

Set RS = DBS.OpenRecordset("Select Cities.Street, Cities.Town, Names.NickName FROM Cities, Names WHERE Cities.Street = Names.Street")

I am not sure if this is what your getting at or not.

[Chris]

you can always use the LEFT/RIGHT JOIN to join two or more fields from different table. All the help can be obtain by press F1 key.

[michelle]

Hello all,

Thanks a lot for the usefull information.

Michelle