I am trying to joing two table and get certain information back based on YEAR.
I've tried a left inner join against TableA, but it excludes certain members. Any help would be great!
My Query:
SELECT MEM_ID,FNAME,LNAME,MNAME,PRIM_EMAIL,PAY1,PAY2,YEAR FROM (
select...