Suchergebnisse

Zitat von SpaceyKevin: „FROM dbo.[RPS24$Prod_ Order Rtng Qlty Meas_] M INNER JOIN dbo.[RPS24$Prod_ Order Routing Line] N ON M.[Prod_ Order No_] = N.[Prod_ Order No_] where M.[Prod_ Order No_]= @Prod_OrderNo_ AND M.[Status]=N.[Status]“ You link the tables two times: once in the INNER JOIN M.[Prod_ Order No_] = N.[Prod_ Order No_] and once in the WHERE statement M.[Status]=N.[Status]

You can change your code to this may be it is better to understand: SQL-Abfrage (6 Zeilen)