Syntax Problem in union query

rajandhla · Posted: Mon Sep 17, 2007 6:02 pm

hi,

I am trying to do union of two queries, but i am facing syntax problem

please correct the following query

SELECT * FROM
(SELECT ABC,DEF FROM X.TABLE1
WHERE ABC=313742
UNION ALL
SELECT ABC,DEF FROM X.TABLE2
WHERE ABC=825748 AS TEMP1)
TEMP1 ;

Thanks in advance

Regards
JR

dick scherrer · Posted: Mon Sep 17, 2007 6:23 pm

Hello,

Do not use "Urgent" in a topic title. One way or another most of the topics are "urgent".

Please post some sample data and the result you want when your query executes.

guptae · Posted: Mon Sep 17, 2007 6:28 pm

Hi There,

Please give

rajandhla · Posted: Mon Sep 17, 2007 8:08 pm

Thanks Ekta...

Is the query will work when i select quallified rows by doing check(condition) on mulitiple tables

like where x.a=y.a and
y.b=Z.b
Z.c=x.c..etc

on union is it possible.

Please let me know thanks..

priyesh.agrawal · Posted: Tue Sep 18, 2007 8:13 am

rajandhla,