select b1.codename, b2.codename, b3.codename, a.count
from t2 b1, t2 b2, t2 b3, t1 a
where a.code1=b1.code and a.code2=b2.code and a.code3=b3.code;
Nandakumar a écrit dans le message <7oc8d0$cs7$1_at_nnrp1.deja.com>...
>There are two tables T1 and T2.
>T1 has Code1,Code2,Code3,Count.
>T2 has Code,CodeName.
>How do i select from these two tables so that i get the result like
>CodeName1, CodeName2, CodeName3, Count.
>
>--
>Nandakumar
>New York
>(N.Kumar_at_rocketmail.com)
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Aug 05 1999 - 10:56:47 CDT
