select a.callno, a.reservee, b.callno 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?

pls help.