sql to earlier post

T

turkey

SELECT [motors in operation to stator assymbly].WONUMBER, [motors in
operation to stator assymbly].[Sta Winding Spec], Winding.W_NO, [High voltage
winding data].W_NO
FROM ([motors in operation to stator assymbly] INNER JOIN Winding ON [motors
in operation to stator assymbly].[Sta Winding Spec] = Winding.W_NO) INNER
JOIN [High voltage winding data] ON [motors in operation to stator
assymbly].[Sta Winding Spec] = [High voltage winding data].W_NO
WHERE ((([High voltage winding data].W_NO) Like [motors in operation to
stator assymbly]![sta winding spec] & "*"));

--
 
Top