By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,415 Members | 1,568 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,415 IT Pros & Developers. It's quick & easy.

Newbie question on a join.

P: 71
I have table X.

In table X, I have 2 fields.

Field 1 is a user name
Field 2 is an account name

I want to find out if account XYZ has both User A and User B as members

I know this is simple, but I'm just out of the hospital and not thinking clearly.
Oct 27 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
Is this an assignment?

You only have one table so no need to do a JOIN.

Just filter your table using WHERE condition.

-- CK
Oct 28 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.