Re: query

From: Frank <F.Preikschat_at_gmx.de>
Date: Fri, 31 Jan 2003 07:13:12 +0100
Message-ID: <b1d43l$rkn$1@news1.ewetel.de>

select t1.id,t1.dt, t1.mt mt1, t2.mt2
from table t1, (select mt mt2 from table ) t2 where t1.typ = 10
and t2.typ = 12
and t1.id = t2.id;

try something like this...

cu Frank (Germany)

Alain <Alain_at_o.fr> schrieb in im Newsbeitrag: 2003130-174647-188072_at_foorum.com...
>
> Hello,
> I have 2 queries :
>
> select id, dt, mt mt1 from table where typ = 10;
> and
> select id, dt, mt mt2 from table where typ = 12;
>
> is it possible to get as result columns:
>
> id dt mt1 mt2
>
> in 1 query ?
>
> Thanks.
>
> --
> Ce message a ete poste via la plateforme Web club-Internet.fr
> This message has been posted by the Web platform club-Internet.fr
>
> http://forums.club-internet.fr/
Received on Fri Jan 31 2003 - 00:13:12 CST