suppose i have five tabels and i must form them html then link them database and php then i want to make query between them these five tabels and data in each one pleaze help me Table of suppliers Source no resource name Address mobile Tel e-mail

Customers table Customer no Customer name Address mobile Tel e-mail

Sales table Sales invoice no History Statement Item Goods number number price color payment Delivery date notes

Table purchases Purchase invoice number Date Number of purchase number statement item Price color payment Delivery date notes

Bucket table Goods number Payment invoice number Purchases Invoice number statement item number Cost price Selling price color Date of entry of the goods status