Ok the error is gone but...
the error is gone but I don't get any data back:
select a.claim_number,a.Net, a.Billed, a.Allowed, a.Copay_Amt, a.IPA_Amt_To_Pay
from dailyClaims as a
join(
Select Count(Distinct Claim_number) AS Claim_Number, Process_Date
FROM dbo.dailyClaims
WHERE Process_Date BETWEEN '06/01/2005' AND '09/30/2005' AND IPA_ID = '823'
GROUP BY process_Date) as b
on a.claim_number=b.claim_number and a.process_date=b.process_date
ORDER BY b.Process_Date
Don't know too much SQL syntax other than the basics That's why I'm asking the expert
so once again my problem now is:
I don't get back any data, I get all the column names but no data
select TOP 100 PERCENT *
from dbo.dailyClaims AS a
JOIN
(Select Count(Distinct Claim_number) AS Claim_Number, Process_Date
FROM dbo.dailyClaims
WHERE Process_Date BETWEEN '06/01/2005' AND '09/30/2005' AND IPA_ID = '823'
GROUP BY Process_Date) AS b
ON a.Claim_Number=b.Claim_Number AND a.Process_Date=b.Process_Date
ORDER BY b.Process_Date
This is what I previously had as a query but it also only gave me the column names but no data returned.
select a.claim_number,a.Net, a.Billed, a.Allowed, a.Copay_Amt, a.IPA_Amt_To_Pay
from dailyClaims as a
join(
Select Count(Distinct Claim_number) AS Claim_Number, Process_Date
FROM dbo.dailyClaims
WHERE Process_Date BETWEEN '06/01/2005' AND '09/30/2005' AND IPA_ID = '823'
GROUP BY process_Date) as b
on a.claim_number=b.claim_number and a.process_date=b.process_date
ORDER BY b.Process_Date