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.