Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Select SQL help needed
I am using the following select statement to select data from one table that doesn't exist in another table. I need to modify it so it selects only data that doesn't appear in the first table or in another table. The select statement currently returns 1303 records. I tried modifying the WHERE clause to read: WHERE (a.ssno NOT IN (SELECT b.ssno FROM helth_priors_tmp b) AND (a.ssno NOT IN (SELECT b.ssno FROM helth_currents_tmp b)
But that returns 29909 records! Any ideas?
SELECT a.dedtype, mnpd, name, prsnid, unit, div, dept, subdept,;
eeclascd, prioradj, a.ssno, a.sortkey, famsingl, frfamsng, dedamnt,;
termcode, paidthru, addcode, adjamt, adjmonth, efctdate,;
a.user_comment;
FROM helthins_view a;
WHERE a.ssno NOT IN (SELECT b.ssno ;
FROM helth_priors_tmp b);
INTO cursor cHelth_tmp3
Jeff
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement