Re: Joined My Head to My Ass

2005-10-21 Thread Jigal van Hemert
G G wrote: I have two tables: Records: member_id - int question_id - int Questions: id - int I'm looking to select a random id from the questions table, given that there is no record of the user already answering that question. SELECT * FROM `Questions` AS t1 LEFT JOIN `Records` AS t2 ON t

Joined My Head to My Ass

2005-10-21 Thread G G
Alright, I like to think I'm relatively competent with MySql, but I need a guru's help with this one as after hours of fooling with it the only thing I've joined is my head to my ass. Here's the deal. I have two tables: Records: member_id - int question_id - int Questions: id - int