| sql [message #66505] |
Wed, 10 July 2002 05:47  |
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  |
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
