ok i go it i think
but it just looks so weird to me..
it looks back wards but works...
SELECT DISTINCT TOP 100 PERCENT dbo.V_riprod_ZMATMAST.sap_partnum AS NEQnumb
FROM dbo.V_riprod_ZMATMAST LEFT OUTER JOIN
dbo.V_riprod_Specs_ZMATMAST_EQ ON
dbo.V_riprod_ZMATMAST.sap_
ok i have 2 views
V_riprod_ZMATMAST returns 60 records
V_riprod_Specs_ZMATMAST_EQ returns 39 records or so that are matched
in another table.
these i will do an update on
problem i am having is the NEQ <>
i am trying to use the view below to return all the results of the
records that don't match.
2 matches
Mail list logo