Join and query two tables for matching data
Posted on 2014-03-17
Good Day Expert,
I am trying to create a query that joins the two tables (FACMatch and CSWMatch) on FirstName, LastName, and Certificate #, with email address from one or both of the tables with matching results.
I am looking for members who moved to FACMatch who are also in the ‘CSWMatch. I am trying to searching by cert number in FACMatch and the Cardholder id in CSWMatch. Also the cardholder id in CSWMatch should have the last two digits removed.
Here is what I have so far, but not quite sure how to join the tables? I tried the wizard but because the tables are not joined the information I would like is not coming out.
Any assistance you can provide would be greatly appreciated.
TRANSFORM Count(CSWMatch.[customer id]) AS [CountOfcustomer id]
SELECT CSWMatch.[lname], CSWMatch.[fname], CSWMatch.[cardholder id (rxclaim member id)], Count(CSWMatch.[customer id]) AS [Total Of customer id]
GROUP BY CSWMatch.[lname], CSWMatch.[fname], CSWMatch.[cardholder id (rxclaim member id)]