General information
Category:
Coding, syntax & commands
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
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