Re: SQL Question

<btomljan_at_vip.hr> wrote in message
news: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

Try something like this:

select * from
(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') A
order by A.datum, a.vrdo

You'll probably need to do some aliasing of the columns, like "select vrdo, u.sif as "sif", ...", but it should work.

p.s. Nadam se da ti je pomoglo. Received on Tue Nov 06 2001 - 10:04:01 CET