General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to use LEFT JOIN
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
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