Get Newest Price from Table for Each Product Code

[Djblois]

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);

[orange]

Your SQL shows 2 adjacent = signs.


.....ASE.PC==ATLN_PRC....

[Djblois]

Still an Error. I didn't think that was it because I pulled it from someone else's code (on the web) that worked and modified it for my own.

[orange]

I see a BASE2 in your original SQL. I've tried to use an alias on the table and adjust the sql. (Untested)

SELECT
Base2.PC
, Base2.PRICE
FROM ATLN_PRC_RTG_BASE as Base2
where
Base2.SDATE In
(SELECT Max([ATLN_PRC_RTG_BASE].[SDATE]) from ATLN_PRC_RTG_BASE where ATLN_PRC_RTG_BASE.PC=Base2.PC);