MySQL Forums
Forum List  »  MySQL Workbench

Advanced Search
New Topic

Re: Columns from multiple tables in one result grid
Posted by: Marco Rios
Date: August 26, 2015 09:36PM

Hi,
you need to associate tables in the form 
SELECT ...
FROM table1 JOIN table2 ON table1.fieldx = table2.fieldy

in the SELECT you ennumerate the columns (or fields) of each table, indicating to wich table they belong, in the form 
table_name.field_name

there are some excellent tutorials and books about SQL language

In the MySQL manual, you can find some useful information, maybe not so easy to apply while you are a complete beginer

Another example:
A Primer on SQL (1st Edition) - Rahul Batra

Thanks in advance for your valuable help.

Acer LENOVO G450
CPU: Pentium(R) Dual-Core CPU T4400 @ 2.20GHz × 2
RAM: 4GB
Graphics: Intel GM45
OS: UBUNTU 18.04.4 LTS 64bits
GNOME 3.28.2
--
Best regards
Marco
Mexico City, Mexico

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Columns from multiple tables in one result grid
2869
Joost van den Broek
August 26, 2015 12:33PM
Re: Columns from multiple tables in one result grid
639
Marco Rios
August 26, 2015 09:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.