View uden dubletter

Der skal vaere N-1 sammenknytnings betingelser med N tabeller.

Enten gammeldags WHERE eller mere moderne ON.

Okay tak!

Hvordan skal jeg angive det i følgende statement? Når jeg kører denne kommer der flere sæt ud

SELECT    Reg.RegistrationNo, Reg.VehicleNumber, Reg.CustomerNumber, Reg.VehicleLicenseNo, Reg.PlantName, Reg.TerminalId, Reg.ArticleName,
                      CAST(Reg.WeightNet AS decimal(12, 2)) AS WeightNet, Detail.UnitPrice, Reg.FeeTotals, Reg.PriceTotals, dbo.Customer.AccountNo, dbo.Customer.AccountNo2,
                      Reg.DateFirst
FROM        dbo.Registration AS Reg INNER JOIN
                      dbo.Customer ON Reg.FacilityId = dbo.Customer.FacilityId AND Reg.FacilityId = dbo.Customer.FacilityId INNER JOIN
                      dbo.RegistrationDetails AS Detail ON Detail.FacilityId = Reg.FacilityId AND Detail.RegistrationNo = Reg.RegistrationNo AND Detail.DetailType = 100 AND
                      dbo.Customer.FacilityId = Detail.FacilityId
WHERE    (Reg.InvoiceState = 0) AND (Reg.Exported = 1)

Okay tak!

Hvordan skal jeg angive det i følgende statement? Når jeg kører denne kommer der flere sæt ud

SELECT    Reg.RegistrationNo, Reg.VehicleNumber, Reg.CustomerNumber, Reg.VehicleLicenseNo, Reg.PlantName, Reg.TerminalId, Reg.ArticleName,
                      CAST(Reg.WeightNet AS decimal(12, 2)) AS WeightNet, Detail.UnitPrice, Reg.FeeTotals, Reg.PriceTotals, dbo.Customer.AccountNo, dbo.Customer.AccountNo2,
                      Reg.DateFirst
FROM        dbo.Registration AS Reg INNER JOIN
                      dbo.Customer ON Reg.FacilityId = dbo.Customer.FacilityId AND Reg.FacilityId = dbo.Customer.FacilityId INNER JOIN
                      dbo.RegistrationDetails AS Detail ON Detail.FacilityId = Reg.FacilityId AND Detail.RegistrationNo = Reg.RegistrationNo AND Detail.DetailType = 100 AND
                      dbo.Customer.FacilityId = Detail.FacilityId
WHERE    (Reg.InvoiceState = 0) AND (Reg.Exported = 1)