SQL inner join
er der nogen som kan hjælpe mig med at finde fejlen:SELECT DISTINCT insurancecompanyID FROM tblReimbursement, tblReimbursementCalculation INNER JOIN tblDamage ON tblReimbursement.damageID = tblDamage.IDdamage INNER JOIN tblShips ON tblDamage.shipsID = tblShips.IDship AND flagID = 4 WHERE IDreimbursement = reimbursementID AND (DateOfCalculation between '01-01-2000' AND '10-12-2005') AND DateOfReceipt IS NULL AND insurancecompanyID = 7
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'tblReimbursement' does not match with a table name or alias name used in the query.
/reports/include/hull_pending_insurance.asp, line 42