Subject | Old-style left join |
---|---|
Author | ainpoissee |
Post date | 2005-03-08T15:18:23Z |
Hi,
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... :(
TIA
ain
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... :(
TIA
ain