Hi guys m working with vs2005 and SQL2005,
When i try to add a query to my table adapter its saying: The schema returned by the new query differs from the base query
And m building the query in the query builder and it says its correct , but when i want to add the query m getting the error here's the query:
SELECT Bestellingen.Totaalprijs, BestellingInhoud.Aantal, BestellingInhoud.Prijs_per_stuk,
BestellingInhoud.Aantal * BestellingInhoud.Prijs_per_stuk AS Expr1
FROM Bestellingen INNER JOIN
BestellingInhoud ON Bestellingen.BestellingID = BestellingInhoud.BestellingID
I hope somebody has any solution m getting sick of that error