467,915 Members | 1,292 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

Newbie question on a join.

Lokean
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
  • viewed: 958
Share:
1 Reply
ck9663
Expert 2GB
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.

Similar topics

reply views Thread by SQL-Newbie | last post: by
3 posts views Thread by Phillip B Oldham | last post: by
4 posts views Thread by MooVBuff | last post: by
2 posts views Thread by rabad | last post: by
5 posts views Thread by Ty | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.