SQL question

Yes this should be done using equi join as above Abhijit Patil mentioned 

Like : select count(column_1) FROM TABLE_A JOIN TABLE_B
                                     ON TABLE_A.coulumn_1 = TABLE_B.column_2 .......

I HOPE THIS IS WHAT U LOOKING IF NOT say i will try to assist you .