silentwolf
Active member
- Local time
- Today, 14:43
- Joined
- Jun 12, 2009
- Messages
- 644
Hi guys,
just wondering if someone could be so kind and let me know where this Syntaxerror (missing Operator) is in that SQL string?
I checked for Typos and it seams to be ok so I guess there is something else causing the Error.
Or is it only a typo that I can't seam to find?
Sorry not that fit with SQL and hoping for some help.
Many thanks for your time!
just wondering if someone could be so kind and let me know where this Syntaxerror (missing Operator) is in that SQL string?
I checked for Typos and it seams to be ok so I guess there is something else causing the Error.
SQL:
SELECT tbl_ArtikelStamm.ArtS_Bezeichnung, tbl_ArtStammPreisliste.ArtSPreis_PreisNetto, tbl_ArtikelGruppenRabatt.ArtGRab_Rabatt,
tbl_ArtStammPreisliste.ArtSPreis_PreisNetto * (1- tbl_ArtikelGruppenRabatt.ArtGRab_Rabatt) AS NettoRabattiert
FROM tbl_Kontakte
INNER JOIN tbl_Preislisten ON tbl_Kontakte.Kont_PreisL_IDRef=tbl_Preislisten.PreisL_ID
INNER JOIN tbl_ArtStammPreisliste ON tbl_Preislisten.ArtSPreis_PreisL_IDRef=tbl_ArtStammPreisliste.PreisL_ID
INNER JOIN tbl_ArtikelStamm ON tbl_ArtStammPreisliste.ArtSPreis_ArtS_IDRef=tbl_ArtikelStamm.ArtS_ID
INNER JOIN tbl_ArtikelGruppenRabatt ON tbl_ArtikelGruppenRabatt.ArtGRab_Kont_IDRef=tbl_Kontakte.Kont_ID
INNER JOIN tbl_ArtikelGruppe ON tbl_ArtikelGruppe.ArtG_ID=tbl_ArtikelGruppenRabatt.ArtGRab_ArtG_IDRef
WHERE tbl_Kontakte.Kont_ID= 123 AND tbl_ArtikelStamm.ArtS_ArtG_IDRef=tbl_ArtikelGruppe.ArtG_ID;
Or is it only a typo that I can't seam to find?
Sorry not that fit with SQL and hoping for some help.
Many thanks for your time!