how to check two database table for missing information

matanb

New Member
i have two tables both have columns of fname and lname how would i write the query to check and see if one of the tables is missing a record that doesnt exist in the other table?here are the tables and its columns \[code\]tbl_client-fname-lnametbl_lease-fname-lname\[/code\]i need to keep checking the tbl_lease to see if the records match the table tbl_client and if it doesnt i would be able to display it to me. thanks
 
Back
Top