I'm no longer clear on who submitted the original question. This may not be accurate syntax, and I've never used RAND(), but I suspect it would solve the problem (at least as I understand the problem). Should work in MySQL 4 and above.
select tgs_questions.q_id from tgs_questions, tgs_quest_ans where tqs_quest_ans.q_id = tqs_questions.q_id and tqs_questions.q_id in (select q_id from tqs_questsions order by rand() limit 0, 5); Mike Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/php-list/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
