테이블 조회
select [열]
from [테이블명]
where[조건]
테이블 조인
select [열1,열2]
from [테이블1]
join [테이블2]
on 조건
ex) 예시
select a.userid, b.money
from usertable as a
join banktable as b
on a.userid=b.userid
고민의 흔적을 늘여놓는 공간
select [열]
from [테이블명]
where[조건]
select [열1,열2]
from [테이블1]
join [테이블2]
on 조건
select a.userid, b.money
from usertable as a
join banktable as b
on a.userid=b.userid