Working examples for outer join & self join in SQL server?

Answer 1

Outer Join

select suppliers.supplier_id, suppliers.supplier_name, orders.order_date
from suppliers, orders
where suppliers.supplier_id = orders.supplier_id(+);

Self Join

SELECT last_name, first_name
FROM employees
WHERE zip in
( SELECT zip
FROM employees
WHERE last_name="Chapple"
AND first_name="Mike")

Answer 2

assuming which you have 2 tables with precisely comparable column, i'd recommend which you carry out UNION quite of OUTER connect. pick * from coachs UNION pick * from gamers; would effect like what you specify. the alternative would be utilizing pick INTO statements for each table to fill the information into the objective table and do favourite question : pick * from purpose;