Insert Command

[Mike Charney]

I am using the following command but it doesnt seem to work. Can any one
tell me why:

Insert Into PAT_MAIN (MRN, PAT_LNAME, PAT_FNAME, PAT_MI, PAT_BDATE, PAT_SEX,
FACILITY_ID) Select MRN, PAT_LNAME, PAT_FNAME, PAT_MI, PAT_BDATE, PAT_SEX,
FACILITY_ID From tblimport Where Not Exists (Select * From tblimport where
tblimport.mrn = PAT_MAIN.MRN)

Sorry it is so long.

Mike Charney

[Randy Harris]

Mike Charney wrote:

I am using the following command but it doesnt seem to work. Can any one
tell me why:

Insert Into PAT_MAIN (MRN, PAT_LNAME, PAT_FNAME, PAT_MI, PAT_BDATE, PAT_SEX,
FACILITY_ID) Select MRN, PAT_LNAME, PAT_FNAME, PAT_MI, PAT_BDATE, PAT_SEX,
FACILITY_ID From tblimport Where Not Exists (Select * From tblimport where
tblimport.mrn = PAT_MAIN.MRN)

Sorry it is so long.

Mike Charney

Mike, I was looking at your earlier post but there didn't seem to be
enough information in that one. I think what you want for your WHERE
clause is:

WHERE tblimport.mrn NOT IN (SELECT DISTINCT MRN from PAT_MAIN)

That should write into PAT_MAIN any MRNs that are in tblimport but not
already in PAT_MAIN. I think that's what you're after, correct?

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

[Mike Charney]

"Randy Harris" <pl****@send.no.spam> wrote in message
news:KF*******************@newssvr13.news.prodigy. com...

Mike Charney wrote:

I am using the following command but it doesnt seem to work. Can any one
tell me why:

Insert Into PAT_MAIN (MRN, PAT_LNAME, PAT_FNAME, PAT_MI, PAT_BDATE,
PAT_SEX, FACILITY_ID) Select MRN, PAT_LNAME, PAT_FNAME, PAT_MI,
PAT_BDATE, PAT_SEX, FACILITY_ID From tblimport Where Not Exists (Select *
From tblimport where tblimport.mrn = PAT_MAIN.MRN)

Sorry it is so long.

Mike Charney

Mike, I was looking at your earlier post but there didn't seem to be
enough information in that one. I think what you want for your WHERE
clause is:

WHERE tblimport.mrn NOT IN (SELECT DISTINCT MRN from PAT_MAIN)

That should write into PAT_MAIN any MRNs that are in tblimport but not
already in PAT_MAIN. I think that's what you're after, correct?

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

Hey Randy,

Ya that is what I wanted. Thanks.