I have the following tables:
Rxs has columns rxno,patid,rono,drug
Rxadmin has columns rxno,patid,rono,admintime.
How to write a query to find all the rono which are in Rxs table but not present in Rxadmin table.
I wrote the below sql
WHERE rxs.rono NOT IN (SELECT rono
WHERE rono IS NOT NULL)
order by rxs.RoNo
Somehow its not giving the right results