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.