>Hi. What would the syntax for a SQL Select be that would:
> "Take all records in Database A, even if there is no match in DBF B"
>
>Thanks, Randy
SELECT * FROM Table_A
<pre>
:o)))
or if you want Table_B to be joined:
<pre>
SELECT * FROM Table_A;
LEFT JOIN Table_B ON ......
....
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.