Inner Join Merge

[krg1140]

1. Using PROC SQL, perform an inner join to merge Audit Fees 2 and Firm Data.  Merge observatiosn where COMPANY_FKEY equals CIK and observations have the same fiscal year (FYEAR).

So far I have: but I'm not sure how to also make it ensure they have the same FYEAR? Any advice? 

proc sql;
create table Firm_Audit as
select *
from audit_fees_4, firm_data
where audit_fees_4.company_fkey=firm_data.CIK
quit;

[ChrisNZ]

1. Use the appropriate icon to paste code

2. What about

where audit_fees_4.company_fkey=firm_data.CIK and audit_fees_4.FYEAR=firm_data.FYEAR