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
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