Clever Geek Handbook

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" enter image description here "question_attempts"enter image description here

+3


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


source






More articles:


All Articles