HI Dears all
I have 2 tables in DB.
My first query is
Select * from lease_north WHERE LaStartDate like '%-04-%' its shows 100 result means 100 payments are due and must be paid in April.
My second query is
Select * from lims_payment WHERE pdate like '%-03-%' I write 03 because if we process in march then cheque will be get ready in march. it shows 80 results .
Can i get this 20 count from just one query.
Please help me.
and how i can use NOT EXIST .