Hi,

Thank for your help but my dbf is located in different location,
so my ODBC location is actually pointing to different location,
will doing the following still work

rs = cnn.Open .....


>You can surely do this using the UNION operator:
>

SELECT Col1, Col2, Col3
>FROM Table1
>WHERE Col1 = Criteria
>UNION
>SELECT Col1, Col2, Col3
>FROM Table2
>WHERE Col1 = Criteria
>ORDER BY Col1, Col2
>

>
>>Hi,
>>
>>Using VB6, is there any way to do a SQL or retrieve data
>>from two dbf file from different location using ADO to
>>form a single recordset which I intend it for use with
>>Crystal Report 8.5.
>>
>>I had tried to use CR query designer, but it can't
>>using ODBC Visual Foxpro driver.
>>
>>Is there any recommend way or refer way to do similar stuff
>>as I want only my Crystal report (.rpt) to pull the
>>required record automatically, without having to have individual
>>form for each report.
>>
>>Please kindly advise.