Data Connection

When performing a SELECT how do I tell my tables are located in different
paths?

I'm doing:
rCON.Open sSQL_C, cnn, , adCmdText.

where
cnn="cnn.Open "driver={Microsoft dBase Driver (*.dbf)};" & _
"driverid=277;dbq=c:\VB\CBS"

sSQL_C="SELECT TABLE1.field1,TABLE1.field2,TABLE2.field1,TABLE2.field2 FROM
TABLE1,TABLE2 WHERE TABLE1.field1=TABLE2.field1 AND ((TABLE1.field1 like
'YL%'))"

TABLE1 is located in c:\VB\CBS
TABLE2 is located in c:\VB\CBS\NP

Any clue?
TIA