Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Question about using select
Message
From
19/07/2004 22:15:37
 
 
To
19/07/2004 22:13:37
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00925999
Message ID:
00926001
Views:
17
select a.callno, a.reservee, b.callno, b.borrower from reserve a, borrower b where a.callno=b.callno

how can i use SELECT-SQL to select all records from table reserve even if it does not satisfy the WHERE condition? but display b.borrower when a.callno=b.callno.

pls help.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform