I wrote a cross apply query in the SQL Management Studio that works how I want it in SSMS, but I can't seem to reproduce a similar query via an access query. The SQL query is below. How would I structure a similar functioned query in access.
Code:
SELECT TOP 100000
SUM(a.[QTY]) AS QTY,
a.[MFGPN],
c.[MANUFACTURER],
c.[DATECODE],
c.[DESCRIPTION],
c.[last_mod]
FROM [DEV].[dbo].[part] a
CROSS APPLY (SELECT TOP 1 * FROM [post].[dbo].[part] b WHERE a.[MFGPN] = b.[MFGPN]) c
GROUP BY a.[MFGPN],
c.[MANUFACTURER],
c.[DATECODE],
c.[DESCRIPTION],
c.last_mod