Re: Outer Join with SQR

[Brian Smith <BSmith@TEMPO.CO.UK>]

Microsoft has not stopped supporting the 'Sybase' syntax for outer joins
using a *, but the preferred syntax is the ANSI OUTER JOIN clause, which is
supported on all versions since 6.5.

Brian Smith



-----Original Message-----
From: Stephen Keen [mailto:stephen_keen@SQR-SERVICES.COM]
Sent: Friday, 19 October 2001 06:46
To: SQR-USERS@list.iex.net
Subject: Re: Outer Join with SQR


Hey David,
One was for an inner join, and the other was an outer join.  For SQL server
I stopped using it because Microsoft was going to stop supporting the way of
joining tables.  Do not know if they have stopped or not?



***IMPORTANT***
The information in this mail is confidential and is intended solely for the
addressee. Access, copying or re-use of information in it by anyone else is
unauthorised. Any views or opinions presented are solely those of the author
and do not necessarily represent those of Tempo Ltd or any of its
affiliates.
"NB Kahn and AV Lomas were appointed Joint Administrators of Tempo Holdings
Limited and certain subsidiaries on 24th September 2001 by order of the
court to manage the affairs and business of the Company without personal
liability. NB Kahn and A V Lomas are licensed to act as Insolvency
Practitioners by the Institute of Chartered Accountants in England and
Wales."