OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: MaxDB 7.6.00.10 Joins and Subquery

From: Daniel Krämer (BigIront-online.de)
Date: Sun Jul 31 2005 - 02:19:14 CDT

Hallo,

am Sonntag, 31. Juli 2005 um 08:43 schrieben Sie:

>> yesterday i install MaxDB 7.6.00.10 on Windows XP SP 2 and i can't make all
>> at the Tutorial:
>>
>> a sample:
>>
>> SELECT customer_zip = zip FROM customer WHERE zip > '90000'
>> SELECT hotel_zip = zip FROM hotel WHERE zip> '90000'
>>
>> give a error.

SK> Well, which error?

SELECT customer_zip = zip FROM customer WHERE zip > '90000'

Error:

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
 Syntax error or access violation;-5015 POS(21) Missing keyword:FROM
SELECT customer_zip = zip FROM customer WHERE zip > '90000'

--
Mit freundlichen Grüßen
Daniel Krämer
mailto:BigIront-online.de

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb