Martijn Tonies wrote:

>>How to rewrite following query to use "old style" left join (join via
>>where)?
>>
>>SELECT
>> RTG.Kuupaev,
>> RTG.PaH,
>> RTG.OhH,
>> RTG.OoH,
>> RTG.NormH,
>> RTG.UusVah,
>> RTG.VahPaevi,
>> Vah.Nimi,
>> Vah.AlgKell,
>> CAST(RTG.Kuupaev + Vah.AlgKell+(Vah.Kestus/1440e0) AS TIME) AS LopKell
>>FROM RepToolepinguGraafik(2005, 3, 5)RTG
>> LEFT JOIN TAB_Vahetus Vah ON(Vah.UID = RTG.Vahetus)
>>
>>I have to join via where as the reporting tool doesn't support JOIN
>>keyword... :(
>
> Outer joins cannot be written in the "old style". Only inner joins can.

Not quite true I believe. But outer joins require "union" queries. No
time to give any specifics right now - look it up!

Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64