Jan 10, 2018 10:40 PM|Rakib1|LINK
i was using below query but getting count as 0 that means no records but as i can see i have record for "Daniel Post" into "Users " table. it should give me count>0.
SELECT Count(cts.first_name | |mngr.last_name) count
FROM Auditors cts
INNER JOIN Users mngr ON cts.first_name = 'Daniel' AND cts.last_name = 'Post'
AND mngr.first_name = 'Daniel' AND mngr.last_name = 'Post'