View Single Post
  #4 (permalink)  
Old October 28th, 2005, 06:59 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
Reply With Quote