Hello,
I have a problem. Maybe someone can help me...:

Can I use a WHERE in a UNION Syntax?. Something like this:

$query = "(SELECT Name, Autor, Typ, Dateiname FROM dokumente)
UNION
(SELECT at.Arbeitsname, ut.Name, at.Type, at.filename
FROM users_table ut, arbeiten_table at
WHERE at.AuthorID=ut.ID)
WHERE Name = some_name";


This doesn't work for me. If this is not possible, how can I get a similar result?

Thanx and greetings,

Nacho

When you say it doesn't work do you mean that you get errors or that you don't get the result set that you expected?

I get an error

if it were me doing it, i would simply put the WHERE condition inside the UNION, in each subselect

SELECT Name, Autor, Typ, Dateiname
FROM dokumente
WHERE Name = some_name
UNION
SELECT at.Arbeitsname, ut.Name, at.Type, at.filename
FROM users_table ut
INNER JOIN arbeiten_table at
ON at.AuthorID=ut.ID
WHERE at.Arbeitsname= some_name

if you really want to add the WHERE clause to the outside of the union, you may need to write it like this --

SELECT *
FROM (
SELECT Name, Autor, Typ, Dateiname FROM dokumente)
UNION
SELECT at.Arbeitsname, ut.Name, at.Type, at.filename
FROM users_table ut
INNER JOIN arbeiten_table at
ON at.AuthorID=ut.ID
)
WHERE Name = some_name

rudy
http://r937.com

Great!
Thank you very much for the help. I tried it and it worked.
Greetings,

Nacho