Help me in a sql query

Hi developers

            Please help me to create a sql query.

I have 4 tables. Below i am giving the discription for those tables

tbpc

column
id        quantity       date        vendor

1              14         15nov       sony
2              24         16nov       Lg

tb_speaker

column  
id             quantity   date          vendor

1    ...