if i put this query in access 2003 it will delete the data but i need to write it in a store procedure and call in from code. how can i make it work?
FROM CUSTNEW LEFT JOIN NADD ON CUSTNEW.ACCT_P = NADD.ACCT_P
WHERE (((NADD.ACCT_P) Is Not Null));
the way it is right now it gives me this error:
"Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'LEFT'.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'NADD'."