(aucun objet)

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... Received on Fri Jan 31 2003 - 01:12:51 CST