Left join problem!

Hi,

I have two tables named SUP, WRK.

I want to join these two tables with few fields

SELECT SUP.*, wrk.*
FROM SUP LEFT JOIN WRK ON SUP.SUPREF = WRK.WRKREF
WHERE 'VARUSH' IN (sup.supanl, sup.supanl2) AND
sup.supsts <> 'X'
ORDER BY SUPANL, SUPDTE.

This statement is working good. I could see all the values from my front end (I am using coldfusion!)

Here is my problem. When I want to add wrk.wrkdte = '08/14/06' like below statement, some of values from wrk is not coming.

SELECT SUP.*, wrk.*
FROM SUP LEFT JOIN WRK ON SUP.SUPREF = WRK.WRKREF AND WRK.WRKDTE = '08/14/06'
WHERE 'VARUSH' IN (sup.supanl, sup.supanl2) AND
sup.supsts <> 'X'
ORDER BY SUPANL, SUPDTE.

This statement also works fine, but some other values of WRK is not coming!

Help would be welcome.

Thanks.

Just guessing, but maybe this will return what you're looking for?

SELECT SUP.*, wrk.*
FROM SUP LEFT JOIN WRK ON SUP.SUPREF = WRK.WRKREF
WHERE 'VARUSH' IN (sup.supanl, sup.supanl2) AND
sup.supsts <> 'X' AND WRK.WRKDTE = '08/14/06'
ORDER BY SUPANL, SUPDTE