Join query

[aswini_1978]

Can anyone help me out !!!!

I am currently using this query which is working fine

SELECT pid, name_last FROM TabA where pid Not In(select pid from TabB where encounter_class_nr=1 and is_discharged=0 ) order by date_reg desc


But its not working in MySQL 4.1 as subquery is not supported

So I want to solve this by join query...

Anyone can reply

Thanx a ton in advance

[artacus]

[code]
SELECT pid, name_last
FROM TabA
LEFT JOIN TabB ON TabA.pid = TabB.pid AND TabB.encounter_class_nr=1 AND TabB.is_discharged = 0
WHERE TabB.pid IS NULL
[/code]