3
As I can in a single SQL statement line, like SELECT * FROM table1 INNER JOIN table2 ON xxxxx, and the desired return would be formed by all fields(columns) of table1 and only one field(column) of table2?
1 answer
3
You will get prefixing (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?
-
1
Simple as that!!! Thank you @Ishmael
Browser other questions tagged mysql sql
You are not signed in. Login or sign up in order to post.
Hello Ronilson, consider accepting my answer if it has been useful to you. If you think she’s incomplete or doesn’t respond to you, make the appropriate comments so I can improve her.
– Ismael