Selecting data from various tables without multiple queries
===

#MySQL - Workbench (PHP):

Tables:

 1. TUsers (One to many relationship with TCompanies):
 - TUsers_CompanyID (FOREIGN KEY)
 - TUsers_UserName
 - TUsers_UserPassword
 - TUsers_ID (UNIQUE)
 2. TCompanies:
 - TCompanies_CompanyName
 - TCompanies_CompanyContactNumber
 - TCompanies_CompanyAddress
 - TCompanies_ID (UNIQUE)

Is it possible to link multiple tables in a relational database without using the JOIN, or INNER JOIN query commands, without duplicating data in tables?

Thus speaking even another way of creating a relationship that makes the one table "point" to the other's data.

So that one can query the following and successfully retrieve **all** the data from **both** tables at once:

`MySQL:`SELECT * FROM TUsers;


###See example above..