SQL Problem

[Anon]

Hello All,

I try to execute the following SQLs in 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

[Anon]

SQL 2 is the problem.

I believe, if my sources are correct, that you cannot have a subquery in php/mysql.

Meaning, you need to take the "( SELECT name FROM tb02 )" out.

If you assign part of the query to a variable, I think you can then use that variable in place of the subquery.

The problem of course is there is slightly a higher chance that one table will change inbetween querys, leading to an unwanted result.

The chance is so small however, and the worst that could happen is you fail to collect all the info you wanted on that particular call.