निर्दिष्ट फ़ील्ड 'Ledger.ID' आपके SQL कथन के FROM खंड में सूचीबद्ध एक से अधिक तालिका को संदर्भित कर सकती है

मेरे कोड: प्रश्न 1: DailySheetQuery

SELECT [Customer Database].ID, Ledger.Customer, Sum([Recable]-[Received]) AS Balance
FROM [Customer Database] RIGHT JOIN Ledger ON [Customer Database].ID = Ledger.Customer
GROUP BY [Customer Database].ID, Ledger.Customer;

प्रश्न 2: डेलीशीट

SELECT Ledger.ID, Ledger.[Transaction Type], Ledger.[Invoice Date], Ledger.Passenger, Ledger.Customer, Ledger.Employee, Ledger.Service, Ledger.Recable, Ledger.Received, Ledger.Payable, Ledger.Paid, Ledger.[Mode Of Payment], DailySheetQuery.ID, DailySheetQuery.Balance, IIf([Ledger].[Mode Of Payment]=2,[Ledger].[Received]-[Ledger].[Paid],0) AS CashInHand, [Ledger].[Recable]-[Ledger].[Payable] AS Profit, [Ledger].[Received]-[Ledger].[Paid] AS [Money]
FROM Ledger LEFT JOIN DailySheetQuery ON Ledger.Customer = DailySheetQuery.ID
WHERE (((Ledger.[Invoice Date])=Date()) AND ((Ledger.Employee)=[Employee #?]));

कृपया मेरी समस्या पर ध्यान दें और सहायता भेजें।

पी.एस. मैं फोरम प्रश्न और उत्तर के लिए नया हूं, अगर कुछ कमी है तो मुझे बताएं।