SQL Syntax
Virker på MS SQL Enterprise (Views) men ikke i Access. ?SELECT g.Navn, l.varetekst, sum(l.Antal) as antal, sum(l.LinieSum) as Beløb
FROM tbcbl l LEFT OUTER JOIN
tbcbh h ON h.FUnique = l.BHUnique LEFT OUTER JOIN
tbcvarer t ON t.FUnique = l.VareUnique AND l.VareType = 'T' LEFT OUTER JOIN
sfvkart v ON v.FUnique = t.VareUnique AND t.VareType = 0 LEFT OUTER JOIN
sfvargrp g ON v.gruppe = g.FUnique
WHERE (h.KasseNr = 5) AND (h.SLTid >= '2005-06-22') AND (h.SLTid < '2005-06-23')
group by g.Navn, l.varetekst
Fejlen lyder: Syntax error(missing operator) in query expression 'h.FUnique = l.BHUnique LEFT OUTER JOIN tbcvarer t ON t.FUnique = l.VareUnique'
