Get a count of matched records
I have two tables named question_answers
and question_attempts
.
question_answers
with parameters with the column name of answer
each question and question_attempts
all attempts to get answers with the column name responsesummary
. Now I would like to get the number of matched records.
"question_answers" 
"question_attempts"
+3
JRK
source
to share
1 answer
These SQLs are useful for getting the number of matching records in two tables.
select count(*) from question_answers as table_1 join question_attempts
on table_1.uniquecolumn_table1 = table_2.uniquecolumn_table2
Thank.
+2
Venkatesh panabaka
source
to share