Hallo,
ich müsste innerhalb meiner Abfrage:
Select
PCH1.ShipDate,
PCH1.BaseRef,
OITM.ItemCode,
OITM.ItemName,
PCH1.Price,
PCH1.Currency,
PCH1.Rate,
OITM.CardCode,
OCRD.CardName
From
OITM Inner Join
PCH1 On OITM.ItemCode = PCH1.ItemCode Inner Join
OCRD On OITM.CardCode = OCRD.CardCode
Where
OITM.CardCode = '70749'
Order By
OITM.ItemCode,
PCH1.BaseRef
den Wert aus PCH1.Price * PCH1.Rate errechnen.
Mein Ansatz war:
Select
PCH1.Price,
PCH1.Rate,
Price*Rate AE Euro
Bin absoluter SQL Neuling, also bitte nicht lachen...
ich müsste innerhalb meiner Abfrage:
Select
PCH1.ShipDate,
PCH1.BaseRef,
OITM.ItemCode,
OITM.ItemName,
PCH1.Price,
PCH1.Currency,
PCH1.Rate,
OITM.CardCode,
OCRD.CardName
From
OITM Inner Join
PCH1 On OITM.ItemCode = PCH1.ItemCode Inner Join
OCRD On OITM.CardCode = OCRD.CardCode
Where
OITM.CardCode = '70749'
Order By
OITM.ItemCode,
PCH1.BaseRef
den Wert aus PCH1.Price * PCH1.Rate errechnen.
Mein Ansatz war:
Select
PCH1.Price,
PCH1.Rate,
Price*Rate AE Euro
Bin absoluter SQL Neuling, also bitte nicht lachen...