SQL Question
From: <btomljan_at_vip.hr>
Date: Sat, 3 Nov 2001 11:45:09 +0100
Message-ID: <MPG.164de9214a2b38d989680_at_news.tel.hr>
Date: Sat, 3 Nov 2001 11:45:09 +0100
Message-ID: <MPG.164de9214a2b38d989680_at_news.tel.hr>
I need to join 3 tables as:
SELECT '1' VRDO, U.SIF,U.KOLICINA,GL.DATUM FROM ULAZ U , ULAZ_GLAVA GL
WHERE SIF ='1001'
UNION
SELECT '2' VRDO, U.SIF,U.KOLICINA,GL.DATUM FROM IZVOZ U , IZVOZ_GLAVA GL
WHERE SIF ='1001'
UNION
SELECT '3' VRDO, U.SIF,U.KOLICINA,GL.DATUM FROM FAKTURA U ,
FAKTURA_GLAVA GL WHERE SIF ='1001'.
It works ok but i need data sorted by GL.DATUM,VRDO.
How can I do that without using temp table.
Thanks
Boris
Received on Sat Nov 03 2001 - 11:45:09 CET