>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
LEFT JOIN
select * from DBFA LEFT JOIN DBFB on DBFA.PK = DBFP.FK
If it's not broken, fix it until it is.
My Blog