-
SELECT - Table join , subquery?(알아보기)DB/Oracle(DB) 2023. 7. 7. 09:31
SELECT ol.*, ci.email, ci.reg_day, cm.kind /*종류 선정 */
from order_list ol, cust_info ci, coffee_menu cm /*테이블 가져오기*/
WHERE ol.cust_id = ci.cust_id
and ol.coffee_no=cm.no
--and cm.kind='커피'
;'DB > Oracle(DB)' 카테고리의 다른 글
UPDATE & DELETE (0) 2023.07.07 SELECT Subquery (0) 2023.07.07 SELECT - 단일테이블 <read> . feat:늦공김부장 (0) 2023.07.06 INSERT<creat> (0) 2023.07.06 connection & table 생성 <creat> (0) 2023.07.06