Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Include del recs in 1st tbl but exclude del recs in join tbl
Message
From
26/03/2002 17:34:57
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Include del recs in 1st tbl but exclude del recs in join tbl
Miscellaneous
Thread ID:
00637576
Message ID:
00637576
Views:
42
I have 2 table, joins on id number. How do I get a result set that includes deleted records in the primary table, but exclude deleted records in the join table?

set deleted off
select last,tbl1.id,descr from tbl1 ;
left join tbl2 on tbl1.id=tbl2.id

The above will give me:
lastname1, id1, descr1
lastname1, id1, descr2
where in tbl2, I have these records:
id1,descr1 (deleted record)
id2,descr2

What I need is:
lastname1, id1, descr1

How can I accomplish that?
THANKS ALL!
Next
Reply
Map
View

Click here to load this message in the networking platform