Select fields to return in a SQL INNER JOIN

Question

Select fields to return in a SQL INNER JOIN

Navigation

#1 by (3 votes)

3

How do I get into a single SQL statement line, type SELECT * FROM table1 INNER JOIN table2 ON xxxxx , and the desired return would be all fields (columns) of table1 and only one field (column) of table2 ? >

mysql sql

asked by anonymous 25.04.2017 / 16:49

1 answer

How to get the value of a cell with dynamic reference What does the data-react attribute mean?

score 3 · Answer 1

You will be able to prefixando (Alias) the tables:

SELECT TBL1.*, TBL2.seu_campo FROM table1 TBL1
INNER JOIN table2 TBL2 ON xxxxx

Related
How to select multiple columns using the table prefix only once?