Menu

#41 sql statement fails

open
nobody
None
5
2004-09-16
2004-09-16
No

the following sql statement fails with assertion error. i
know that the statement is not nice, but it is correct for
sql87:

SELECT
ART.WarenGruppe AS WGr,
ART.ArtNr AS ArtikelNr,
ART.Einheit AS Einheit,
ART.Bezeichnung AS Bezeichnung,
ART.RabattGr AS Rabattgruppe,
VERKAU.Anzahl AS Staffel,
VERKAU.Verkaufspreis AS Verkaufspreis,
VERKAU.Waehrung AS Währung,
VERKAU.Preiseinheit AS Preiseinheit,
VERKAU.PreisGr AS Preisgruppe,
VERKAU.VKArt AS VKArt,
VERKAU.Einstandspreis AS Einstandspreis,
VERKAU.DatNr AS DatNr,
VERKAU.Verpackungseinheit AS Verpackungseinheit,
VERKAU.Verpackungsfaktor AS Verpackungsfaktor,
AdrArt.AdrArtNr as AdrArtNr
FROM
ART LEFT OUTER JOIN
(VERKAU LEFT JOIN ADRART ON
(VERKAU.DatNr=AdrArt.DatNr) AND
(VERKAU.PreisGr=AdrArt.AdrNr) AND
(VERKAU.ArtNr=AdrArt.ArtNr))
ON (ART.ArtNr=VERKAU.ArtNr)

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.