General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>In SQL, when you define a join condition i the way you're doing it, it comes out as a inner join. I.E. the result set contains the records that have match in both tables only. If there is a record from table 1 that the sql doesn't find a match in table 2, then it isn't included in the result set.
>
>In order to do what you're seeking, you have to explicitly make a left join, the syntax being:
>
>SELECT BALANCE.* FROM BALANCE left join PTYPES on BALANCE.TYPE=PTYPES.TYPE where EMPTY(PTYPES.TYPE) INTO DBF ANYTABLE
Thanks for the fix Francisco
my first reaction was "thats all very well, but how did it pick up the valic records?" but of course, they match in both tables, so no prob.
thanks again
Harry
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only