distinct join

[anakadote]

hi. ok, so here's my problem: i have two tables, say users and items. each user has multiple items. i just want to select one of the items along with the information in the users table, for each user that has at least one thing in the items table. i would also like the item randomly selected if at all possible.

thanks much!

[CaptainD]

Look into using Rand()

That should point you in the right direction.