Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use LEFT JOIN
Message
From
16/03/2002 13:13:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to use LEFT JOIN
Miscellaneous
Thread ID:
00633770
Message ID:
00633770
Views:
36
ear Friends

I am describing my problem below, please send me some solution.

I have two DBF - EMPL.DBF and EMPSEC.DBF.
EMPL.DBF have three field - EMP_ID, EMP_NAME, EMP_ADDRESS and
EMPDESC have two field - EMP_ID, EMP_SECTION.

EMPL.DBF have 25 records out of them 3 are marked deleted and EMPSEC.DBF
have 10 records and 1 record is marked deleted and Both are joined with
EMP_ID field.

I like to write a query which show all the records from EMPL.DBF and joined
with EMPSEC.DBF but not the deleted records.

I have tried like the following but it didn't worked (may be syntax error)

Select a.emp_id, a.emp_name, a.emp_address, b.emp_section ;
from empl a, left join empsec b ;
where a.emp_id == b.emp_id and ;
not deleted(a) and ;
not deleted(b) ;
into cursor temp


Thank you

Aritra
Next
Reply
Map
View

Click here to load this message in the networking platform