Worked like a charm!!

I originally started with a sub query, but without success changed to the left join... I see now why it was failing.

Sean, Thanks for your help on...

Sean, Thanks for your reply and the article... Hopefully I've done it correctly

Here is the info to create the results

-- ===== If the test table already exists, drop it

...

Thanks SQL Junkie,

Looks like the postings crossed paths

Thanks for the reply

I found that this also worked faster (suggestions/comments are welcome too)

SELECT * FROM tblNumbers

WHERE

RecNum NOT IN

(

SELECT SomeNum FROM tblNumA

UNION

SELECT SomeNum FROM tblNumB

)

My Mistake,

I had the same data in each table, returning 0 results.

I've since added data NOT IN the other tables and it worked fine

Worked like a charm!

I really appreciate your help

Thank you,

Rick

Jo,

Thanks for the help (and quick response), I was able to get started in the right direction.

Although I am having one seemingly small problem.

When I set the ORDER BY NewID()...

Hi, it's me again.

I see that a few people have read this post, but I feel that I hadn't explained what I was trying to do as clearly as I'd...

KH,

Thanks for the answer,

I'll know for next time as I should be using some more of these down the road

Thanks again

Rick

Scott & Rajesh

Thanks for your input.

I almost had it after your comment Rajesh, but I was still a few steps away.

Scott, thanks for your post, I was able to get...

Thank you Prasad!

It worked perfectly!

Rick

Hi,

I purchased a copy of SQL 2000 Standard 1 processor on Ebay about a year ago.

As part of the agreement with the seller, I sent the product to Microsoft for...

Thanks Dogeth

It worked great!

quote:

---

Use brackets in your where clause.

...

WHERE

(

tblProfile.Education = 'Some College'

OR tblProfile.Education = 'Associates Degree'

)

AND tblProfile.MemberIDpr = tblUsers.MemberID

...

---

Thank you

It worked great!

Thank you!

Rick