how to retrieve data from more than one table

Schema:-

Part(pid, pname, price) 

Supplier(sid, sname,city)

Part_Supplier(sid, pid)

Q1) Get the supplier_id and the name for those suppliers who supply all parts.

Q2) Get the part_id and name for those parts where the price of the part is greater than 3000 and is supplied by more than 3 suppli开发者_如何学编程ers.

Kindly help me with this as I am not able to figure this out. Any help will be highly appreciated.

As I mentioned in my comment, you shouldn't ask questions like this. You would easily be able to solve this problem if you did a basic SQL tutorial. Try this one: http://www.w3schools.com/sql/default.asp

Pay particular attention to SQL joins.