Roy Harvey
3/19/2007 12:52:00 PM
There are a number of ways to do this, but most become long and
complicated. This may be the simplest.
SELECT Name
FROM tbl_J as A
WHERE EXISTS
(SELECT * FROM tbl_CJ as B
WHERE B.CJ_ID = 23515
AND A.J_ID IN
(B.J1, B.J2, B.J3,
B.J4, B.J5, B.J6))
ORDER BY Name
Roy Harvey
Beacon Falls, CT
On 19 Mar 2007 05:39:00 -0700, "Giorgio" <FJMartinho@googlemail.com>
wrote:
>Can someone tell me options to do this statment because this one does
>not work!
>
>SELECT Name FROM tbl_J
>WHERE J_ID IN
>(SELECT J1, J2, J3, J4, J5, J6
>FROM tbl_CJ
>WHERE CJ_ID =23515) ORDER BY Name