General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks for the replies.
I have actually found a way around this.
If I SET DELETED OFF before the selected, then run
SELECT table1.*,table2.*;
FROM table1 LEFT OUTER JOIN table2;
ON table1.key = table2.key;
WHERE !DELETED("table1")
It will bring me the non-deleted records from the 1st table and ALL records from the 2nd table.
Thanks
Kev
Previous
Next
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