MySQL - Workbench (PHP): Linking data in multiple tables WITHOUT JOIN query command -


MySQL - WorkBank (PHP):

Is it possible to link multiple tables in relational databases , Or INNER join query command without replacing the data in the table? For example, I have two tables with columns:

  1. TUsers (related to TCompanies, 1-N)

      < Li> ID_UserContactNumber
    • / Li>
    • Ol>

      In short; I want to use COMPANY data from the user table without the JOIN query between the two tables ...

      It depends on what you are trying to do, you can use a block, but you do not find any such field, which indicates to connect between two tables, whether in any of the two tables Is a foreign key?

      Since you refer to that you can do the following in the TUsers table in TUsers_CompanyID : SELECT TUsers.TUsers_UserName, TUsers by TCompanies.Tcompanies_CompanyName, TCompanies where TUsers.TUsers_CompanyID = TCompanies.ID_TCompanies;

Comments

Post a Comment