SQL Basics - Joins 정보
SQL Basics - Joins본문
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;
링크를 클릭하세요
공감
0
0
댓글 0개