Home » RDBMS Server » Networking and Gateways » sql
sql [message #66505] Wed, 10 July 2002 05:47 Go to next message
Milind
Messages: 8
Registered: February 2002
Junior Member
i'm trying to do the following:

SELECT CATEGORY_DESCRIPTION, PACKAGE_CODE
FROM CATEGORY INNER JOIN PACKAGE_DETAILS
ON CATEGORY.CATEGORY_CODE = PACKAGE_DETAILS.CATEGORY_CODE;

but get :

FROM CATEGORY INNER JOIN PACKAGE_DETAILS
*
ERROR at line 2:
ORA-00933: SQL command not properly ended

any ideas anyone???
Re: sql [message #66506 is a reply to message #66505] Wed, 10 July 2002 06:49 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
Do you use Oracle ??? It's a MySQL script, isn't it ?
Try this:

SELECT CATEGORY_DESCRIPTION, PACKAGE_CODE
FROM CATEGORY,PACKAGE_DETAILS
WHERE CATEGORY.CATEGORY_CODE = PACKAGE_DETAILS.CATEGORY_CODE;
Previous Topic: Max connection to one Oracle instance
Next Topic: getting max date from multiple columns
Goto Forum:
  


Current Time: Sun Feb 25 05:58:34 CST 2024