Re: OUTER JOIN

Hello

I'd probably write the query something like this:

SELECT ST.id, ST.order_num, ST.from_time, ST.to_time, ST.disabled,
SD.description
FROM shift_type ST LEFT OUTER JOIN shift_desc SD
ON (ST.id = SD.shift_type_id AND SD.app_language_id = 2)
ORDER BY ST.order_num

I haven't tried the query, so I'm not all sure it works though =)

Regards,
Patrik Kudo

Marco Roda wrote:
> Hallo,
>
>
> and here is the SQL for Oracle:
> SELECT ST.id, ST.order_num, ST.from_time, ST.to_time, ST.disabled,
> SD.description
> FROM shift_type ST, shift_desc SD
> WHERE ST.id = SD.shift_type_id(+) AND SD.app_language_id(+) = 2
> ORDER BY ST.order_num
>