How can I write a SQL query using TableA that has a temporary/work field
based on the value in TableB?

Example:  a 'Delete' indicator field on tbl_Books based on
'Last_date_rented' < '01/01/95' FROM TBL_RENTAL

SELECT BOOK_ID, DELETE_INDICATOR FROM TBL_BOOKS WHERE 

????
DELETE_INDICATOR = 'Y' IF 'LAST_DATE_RENTED' < '01/01/95' IN TBL_RENTAL??

THANK YOU IN ADVANCE FOR YOUR HELP.


VAS CHELLAPPA