Randy

If you are Matching records in table A to table B

left join = all records in table a and matching records in table B
inner join = all matching records in both table A and B
right join = all records in b and all matching records in a

Gaylen

>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