Re: Outer Join in PSQL 7

#1

SELECT * FROM "Table1", "Table2"
WHERE "Table1"."JoinField" = "Table2"."JoinField" (+)

Good day,
Rok

Adam Augusta wrote:

Quote:

Good day, gents.

I'm trying to do a very simple outer join in Pervasive SQL 7. Is it
possible? I know that 8 can do it, but upgrading is not an option.

SELECT * FROM "Table1" LEFT OUTER JOIN "Table2" ON "Table1"."JoinField" =
"Table2"."JoinField"

returns the error: "The syntax in the WHERE clause is invalid".
The older syntax:

SELECT * FROM "Table1", "Table2" WHERE "Table1"."JoinField" =*
"Table2"."JoinField"

returns the error: "The syntax for an expression or restriction clause is
invalid."

You can't call yourself SQL if you can't do outer joins. Is there a way
to do an outer join in PSQL7, or do I have to revert to a bunch of ugly
subqueries?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Outer Join in PSQL 7

comp.databases.btrieve comp.databases.btrieve

Re: Outer Join in PSQL 7 - 07-24-2003 , 01:56 AM