Re: sql query question

select name,id,city,temp
from (select name, id, rownum row_num from emp) t1, (select city, temp, rownum row_num from forcast) t2 where t1.row_num=t2.row_num;

--
Regards

Emmanuel HUMBLOT e_humblot_at_wanadoo.fr

GreyWolf_69 <GreyWolf_69_at_alloymail.com> a écrit dans l'article <38887456.571BD9AF_at_alloymail.com>...
> Hi,
> I was wondering if there was a way to have two different queries in
> a script
> that would write the results to the same line(s) in a file? The two
> queries don't have
> any common keys or fields.
>
> ex:
>
> query one: select name, id from emp;
> query two: select city, temp from forcast;
>
> ex of output that I'm looking for:
>
> name id city temp
> Don 001 Taos 85
>
> TIA,
>
> Grey
>
>
>
>
Received on Fri Jan 21 2000 - 10:58:55 CST