How do I?

Forum|Forum|19 years ago
November 7, 2006
1 reply
400 views

Hi, I thought I had a solution working for this problem, however when I ran it in coldfusion, the result set was different then when I ran it in the sql viewer.

Anyway... this is what I want to do.

I have two tables. A column in both call [employee id].

I want to pull the column from one, only if it is NOT IN two.

Any ideas? I am on cough medicine today and really having a hard time concentrating... Thanks.

Database access

This topic has been closed for replies.

D

Dan_Bracuk

Inspiring

There are more than one way. Some are db specific. Most resemble this:

select fields
from tables
where table1.employee_id not in
(select employee_id from table2)

S

SilentBob_secretfusionAuthor

Known Participant

Thanks. I need to take some time off.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded