SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple LEFT JOIN

967659Oct 11 2012 — edited Oct 11 2012

I'm trying to do a multiple join between three tables. Is it somehow possible to do this with this syntax where I only use the keywords LEFT JOIN and ON once?

SELECT
	DW_STAR.PA_POSTER_FACT.*
FROM
	DW_STAR.PA_POSTER_FACT
LEFT JOIN
	DW_STAR.LEVERANDOER_DIM,
	DW_STAR.FAKTURAFILER
ON
	DW_STAR.PA_POSTER_FACT.LEVERANDOER_DIM = DW_STAR.LEVERANDOER_DIM.DIMENSION_KEY AND
	DW_STAR.PA_POSTER_FACT.FAKTURA_BILAGSNUMMER = DW_STAR.FAKTURAFILER.FAKTURA_ID
WHERE
	ROWNUM < 10

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2012

Added on Oct 11 2012

#pl-sql, #plsql

4 comments

622 views