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.

[ck9663]

Is this an assignment?

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

Just filter your table using WHERE condition.

-- CK