SELECT *
FROM emp
SELECT emp.empno, emp.ename, emp.deptno
FROM emp, dept
WHERE emp.deptno = dept.deptno
order by emp.deptno;
SELECT *
FROM emp
SELECT *
FROM dept
SELECT e.empno, e.ename
FROM emp JOIN dept ON (emp.deptno = dept.deptno)
join0_1 ]
SELECT emp.empno, emp.ename, emp.deptno, dept.dname
WHERE emp.deptno = dept.deptno
AND emp.deptno IN ( 10, 30 )
ORDER BY emp.deptno;
join 0_2 번
SELECT emp.empno, emp.ename, emp.deptno, dept.dname ]
FROM emp JOIN dept ON (emp.deptno = dept.deptno )
WHERE emp.deptno = dept.deptno
AND emp.deptno IN ( 10, 30 )
ORDER BY emp.deptno;
4qks
SELECT emp.empno, emp.ename, emp.sal, dept.dname ]
FROM emp JOIN dept ON (emp.deptno = dept.deptno )
WHERE emp.sal >2500
AND emp.emptno > 7600
ORDER BY emp.deptno;
SELECT *
FROM emp
SELECT *
FROM dept
SELECT dept.dname, emp.ename , emp.job
FROM emp NATURAL JOIN dept;
모든 행을 대상으로 계수물어보면 count group by 쓰지 않고
------------------exerd
SELECT *
FROM PROD
SELECT *
FROM LPROD
SELECT lprod.lprod_gu, prod.prod_id, prod.prod_name
FROM prod, lprod
WHERE lprod.lprod_gu = prod.prod_lgu
SELECT COUNT(*)
FROM prod;
SELECT COUNT (*)
FROM LPROD, PROD
WHERE prdo.prod_1gu
SELECT COUNT(*)
FROM
SELECT * BUYER_ID BUYER_NAME
FROM buyer
SELECT * PROD_ID PROD_NAME
FROM prod
공통 : PROD 에서의 PROD_BUYER 와 BUYER에서의 BUYER ID
SELECT BUYER_ID , BUYER_NAME , PROD_ID, PROD_NAME
FROM buyer , prod
WHERE PROD.PROD_BUYER = BUYER.BUYER_ID
SELECT BUYER_ID , BUYER_NAME , PROD_ID, PROD_NAME
FROM buyer JOIN prod on ( PROD.PROD_BUYER = BUYER.BUYER_ID )
join 3
SELECT member.mem_id, member.mem_name, prod.prod_id, prod.prod_name, cart.cart_qty
FROM member , cart, prod
where member.mem_ID = CART.CART_MEMBER
AND cart.cart_prod = prod.prod_id;
join 3번
ansi 랑 join 으로 풀기.
SELECT member.mem_id, member.mem_name, prod.prod_id, prod.prod_name, cart.cart_qty
FROM member JOIN cart ON
where member.mem_ID = CART.CART_MEMBER
AND cart.cart_prod = prod.prod_id;
join 4 ~ 7
join 4
댓글
댓글 쓰기