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... :(

Outer joins cannot be written in the "old style". Only inner joins can.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com