sql help <> NEQ

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. so i can do an Insert... SELECT DISTINCT TOP 100 PERCENT ABS(dbo.V_riprod_ZMATMAST.sap_partnum) AS pnum2 FROM         dbo.V_riprod_ZMATMAST INNER JOIN                       dbo.V_riprod_Specs_ZMATMAST_EQ ON dbo.V_riprod_ZMATMAST.sap_partnum <> dbo.V_riprod_Specs_ZMATMAST_EQ.sap_partnum WHERE     (dbo.V_riprod_ZMATMAST.sap_partnum <> N'dbo.V_riprod_Specs_ZMATMAST_EQ.sap_partnum') i am using mssql2000 ent viewer. have tried left outer join & a bunch of wierd stuff, and just keep getting funky results... This works for counting.... rcdCT  TotalCount  EqCount  NeqCount 1     60                 39      21    SELECT     TOP 100 PERCENT COUNT(*) AS rcdCT, dbo.V_riprod_Specs_ZMATMAST_Count.rcdCT AS TotalCount,                       dbo.V_riprod_Specs_ZMATMAST_EQ_Count.rcdCT AS EqCount,                       dbo.V_riprod_Specs_ZMATMAST_Count.rcdCT - dbo.V_riprod_Specs_ZMATMAST_EQ_Count.rcdCT AS NeqCount FROM         dbo.V_riprod_Specs_ZMATMAST_Count CROSS JOIN                       dbo.V_riprod_Specs_ZMATMAST_EQ_Count GROUP BY dbo.V_riprod_Specs_ZMATMAST_Count.rcdCT, dbo.V_riprod_Specs_ZMATMAST_EQ_Count.rcdCT

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_partnum = dbo.V_riprod_Specs_ZMATMAST_EQ.sap_partnum WHERE     (dbo.V_riprod_Specs_ZMATMAST_EQ.sap_partnum IS NULL) ORDER BY dbo.V_riprod_ZMATMAST.sap_partnum