>Hi
>
>I have a select with two tables that LEFT OUTER JOIN, I want the joined table to include it's deleted records as well as the non-deleted ones.
>
>Any ideas on how to sort this? I have tried SELECT.....WHERE DELETED("table2") OR !DELETED("table2").
>
>Thanks
>Kev
Using the SET DELETED command before the Select should do what you want. Look up the command in your help and see what SET DELETED ON/OFF will do.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope