Oracle SQL Problem
| From: | Old Keung | Date: | Sun, 08 Oct 2000 01:53:55 +0000 |
| Subject: | Oracle SQL Problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3400@lists.php.net to get a copy of this message | ||
Hello All,
I try to execute the following SQLs from php:
SQL 1:
SELECT name FROM tb01
UNION ALL
SELECT name FROM tb02
SQL 2:
SELECT name
FROM tb01
WHERE name IN (
SELECT name FROM tb02
)
The result is "Invalid Column Name" for each SQL statement.
I am using php4, Oracle and openlink. I have tested the above statement in
Oracle sqlplus and they work. But when I execute exactly the same sentence,
it doesn't work.
Could anyone point out where is the problem? Does the openlink has different
syntax for the SQL statement?
Thanks in advance.
William