Join에 대해서는 별도로 설명..

제품을 Join시킨경우

select * from customer.orders
inner join Products on Orders.ProductId=Products.id;

as로 긴 네임을 짧게

select * from customer.orders as o
inner join Products as p on o.ProductId=p.id;

AS도 줄이자..

select * from customer.orders o
inner join Products p on o.ProductId=p.id;

전체를 볼 필요없이

select o.*, p.*, c.* from customer.orders o
inner join Products p on o.ProductId=p.id
inner join Customer c on o.CustomerID=c.id;

필요한 것만 표시하자..

select o.OrderDate, p.ProductName, p.Price, c.* from customer.orders o
inner join Products p on o.ProductId=p.id
inner join Customer c on o.CustomerID=c.id;

링크를 클릭하세요