Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Error: "Name not unique in this context"

edited January 2003 in End User
Hi

I'm trying to link two queries when both are using the same tables and
calculations with different criterias and when I try to veiw the data from
detail query it displays this message "Name not unique in this context".

Query1 Master
SELECT ReceiveDetail.MasterID,
SUM(ReceiveDetail.Amount) SUM_ReceiveDetail_Amount
FROM "ReceiveDetail" ReceiveDetail
WHERE ( ReceiveDetail.CampaignID = "P2001" )
GROUP BY ReceiveDetail.MasterID

Query2 Detail
SELECT ReceiveDetail.MasterID,
SUM(ReceiveDetail.Amount) SUM_ReceiveDetail_Amount
FROM "ReceiveDetail" ReceiveDetail
WHERE ( ReceiveDetail.CampaignID = "P2002" )
GROUP BY ReceiveDetail.MasterID

if anyone knows how to bypass this error let me know please.

Thanks
Sam

Comments

This discussion has been closed.