473,507 Members | 12,693 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Newbie question on a join.

Lokean
71 New Member
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
1 1034
ck9663
2,878 Recognized Expert Specialist
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

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

Similar topics

52
6270
by: MP | last post by:
Hi trying to begin to learn database using vb6, ado/adox, mdb format, sql (not using access...just mdb format via ado) i need to group the values of multiple fields - get their possible...
3
1363
by: BirdByte | last post by:
Using Access 2000, how does a record chosen on one form get transferred to another form? A user choses a record in form 1, and presses a button which opens form 2. I want to work with that record in...
1
1169
by: taoh15 | last post by:
Hi All Although I have been using SQL2K for a number of years this is my first venture into more complicated stuff. I have a query SELECT apd.elid , apd.pcid , apd.apstatid , ap.empid ...
0
1256
by: SQL-Newbie | last post by:
Hi, I'm new to SQL trying to use a base that was set up by another firm. I can't get it to do what I want and I don't know if it's due to my ignorance or bad table design ... I have three...
3
4222
by: Phillip B Oldham | last post by:
Hi. I'm stretching my boundaries in programming with a little python shell-script which is going to loop through a list of domain names, grab the whois record, parse it, and put the results into a...
17
1460
by: takayuki | last post by:
Hi, I'm studying python via the exellent book "How to think like a python programmer" by Allen Downey. Noob question follows... animals.txt is a list of animals, each on a separate line:...
4
977
by: MooVBuff | last post by:
I am new to VB.2005 and to make it worse, I'm switching over from VB 6.0. I have figured out how to programmatically Create a Database and Table and how to add data to an Access database (Two weeks...
2
8942
by: rabad | last post by:
Hi, I've created a custom filter based on HTMLParser, with the following source: class Filter(HTMLParser): def __init__(self, keyfile): HTMLParser.__init__(self) mykwfile = open(keyfile,...
5
2390
by: Ty | last post by:
I'm new to SQL but not Excel I was given a Excel spreadsheet with Employee names. I have a large database with a Personal Table with Employee names and a whole list of other tables that I'm...
2
987
Lokean
by: Lokean | last post by:
Okay, this works, but there has GOT to be a cleaner way of doing this. Suggestions please. DECLARE @TMP TABLE ( HOLD1 NUMERIC, HOLD2 NUMERIC, HOLD3 NUMERIC, HOLD4 NUMERIC,
0
7223
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7314
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
7030
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7482
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5623
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4702
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3191
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
411
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.