In SQL Server how to get unmatched records from one table

how to get unmatched records from two tables in sql server using join
how to get unmatched records from two tables in oracle
sql query to compare two tables and find records without matches
how to get unmatched records from left tables in sql
mysql compare two tables to find unmatched records
sql query to compare two tables and find records with mismatches
mysql compare two tables to find matched records
access find records not in another table