maria db natural, left join 동시 사용 여러 테이블에서..

[oracle]

select *
from A, B, C
where A.id = B.id
and A.id = C.id(+)

[maria]
다음이 되지 않음. from 뒤에 테이블이 두 개 동시에 나와서 그런 것임.

select *
from A, B
left C
ON A.id = C.id
where A.id = B.id

아래와 같이 가야 함.
select *
from A
join B
left join C
on A.id = C.id
where A.id = B.id

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s