php - Selecting data from various tables without multiple queries -

MySQL - Workbench (PHP):

Tables:

1. TUsers (a) to many relationship with TCompanies:
   • TUsers_CompanyID (foreign key)
   • TUsers_UserName
   • TUsers_UserPassword
   • TUsers_ID (unique)
   • TCompanies:
     • TCompanies_CompanyName
     • TCompanies_CompanyContactNumber
     • TCompanies_CompanyAddress
     • TCompanies_ID (unique ) Join

       to join more than one of the tables in a relational database without using it, or joining the inner query commands, the table Is not possible without data duplicates?

       There is another way to create a relationship in this way, which makes a table "point" in the data of another.

       So that someone can ask the following questions and successfully all both data from the table at one time:

       MySQL : SELECT * fROM TUsers, up

       see example ..

       < p> join> to not query join without it can "be the" join in a display (ie, write), but still uses a MySQL ... Select Sector Tiyuesrs, Tikanpanifiks where Tiyuesrs_kanpaniaidi = Tikanpanijian_aidi;