query

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/