>>>>> On Thu, 30 Aug 2001 20:41:30 +1000, Helen Borrie <helebor@...> said:

>> from vacancyturnaroundtimereport
>>
>> join VacancyOverView(vacancyturnaroundtimereport.companyid,
>> vacancyturnaroundtimereport.vacancyid) on 1=1

HB> This isn't valid join syntax.

HB> The join syntax is

HB> select a.Something ... , b.somethingelse...

HB> from aTable a join bTable b on a.Keycolumn = b.Keycolumn

HB> and

HB> "on 1=1" would have no meaning to the IBO parser or to the
HB> server.

I use that syntax a lot with stored procedures (well, actually I use a
LEFT JOIN), and I have never had problems! It must be something
else...

bye, lele.
--
nickname: Lele Gaifax | Hold on, hold on - They put you in a box so you
real: Emanuele Gaifas | can't get heard - Let your spirit stay unbroken,
email: lele@... | may you not be deterred - P.Gabriel "Wallflower"