I need to create a query that always pulls the newest price from each PC. Here is the SQL that I tried but I am getting a syntax error:

SELECT ATLN_PRC_RTG_BASE.PC,  ATLN_PRC_RTG_BASE.PRICE where ATLN_PRC_RTG_BASE.SDATE IN
(SELECT Max([ATLN_PRC_RTG_BASE].[SDATE]) from ATLN_PRC_RTG_BASE where ATLN_PRC_RTG_BASE.PC==ATLN_PRC_RTG_BASE2.PC);