In Access, I have two tables
Users(userID, UserName, Password, bool Online) and
Contacts(UserID, ContactID)
In Jet SQL please help me retrieve the username of contacts of a particular username
who are online.
please help me, i am stuck.

SELECT [UserName], [bool Online]
   FROM Users
   WHERE [bool Online] = True ' or Yes or -1 depending on your table design



mmcdonal

Sorry, I didn't get the second table... hang on a sec...

mmcdonal

SELECT Users.UserName, Contacts.ContactID, Users.[bool Online]
FROM Users INNER JOIN Contacts ON Users.UserID = Contacts.UserID
WHERE (((Users.[bool Online])=Yes));

Where are you trying to make this query? Where are you getting the UserName?

HTH

mmcdonal

i wanted to retrieve the contacts name. this query retrieves only the Contacts UserID. please help