[GENERAL] Inner Join?

2001-07-10 Thread Jeff Rhys-Jones
Hi there - we've hit a bit of a brick wall with this and I was wondering if someone could help us out. Our MS-SQL code is this : SELECT "Site"."Name" as "SiteName", "Site"."Description" as "SiteDescription", "Site"."DefaultStyle", "Site"."PageWidth", "Site"."Tel", "Site"."Fax", "Site"."Email",

RE: [GENERAL] Inner Join?

2001-07-17 Thread Jeff Rhys-Jones
Tom... you are totally right. We had version 7.03 installed - which didn't support OUTER hence we couldn't figure this thing out! Many thanks to all! Jeff -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: 11 July 2001 00:32 To: Jeff Rhys-Jones Cc: [EMAIL