View Single Post
  #5 (permalink)  
Old January 21st, 2005, 04:43 AM
ChrisScott ChrisScott is offline
Friend of Wrox
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Leo,

This should do it...
Code:
SELECT DISTINCT u.UserId, u.username, u.fname, u.email, p.photoname, p.isactivated 
FROM users u INNER JOIN photos p ON u.UserId = p.UserId;
HTH,

Chris

Reply With Quote