What is wrong with this SELECT

#1

I am new to Pervasive.SQL 8 and I am trying to execute a simple two
table join. When I do I get the following error.

ODBC Error: SQLSTATE = 37000, Native error code = 0
Syntax Error: SELECT C.NAME, A.* FROM
paClient C JOIN<< ??? >> paAddr A
ON C.ADDRR = A.RR

The paAddr table does exist and a SELECT * FROM PAADDR works fine.

What am I doing wrong?

--
_Bill_

#2

Ignor my question. I found the problem.

--
_Bill_

Bill wrote:

Quote:

I am new to Pervasive.SQL 8 and I am trying to execute a simple two
table join. When I do I get the following error.

ODBC Error: SQLSTATE = 37000, Native error code = 0
Syntax Error: SELECT C.NAME, A.* FROM
paClient C JOIN<< ??? >> paAddr A
ON C.ADDRR = A.RR

The paAddr table does exist and a SELECT * FROM PAADDR works fine.

What am I doing wrong?

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

What is wrong with this SELECT

comp.databases.btrieve comp.databases.btrieve

What is wrong with this SELECT - 09-30-2004 , 06:10 PM

Re: What is wrong with this SELECT - 09-30-2004 , 07:01 PM