I'll try to describe what I want to get. Example of a tables:
When I write query to show all records from table B, I can see in the column NAME only index ( 1,2,3 )
"SELECT ID, NAME FROM TABLE_B"
And I would do so: "SELECT ID, (INNER JOIN TABLE_A ON NAME=TABLE_A.ID) FROM TABLE_B"
This query is obviously wrong. Is there something similar in SQL queries?
I tried: "SELECT ID, NAME=(SELECT ID FROM TABLE_A) FROM TABLE_B"
but I get reply: "Subquery returns more than 1 row" and I understand it as I want to main query to return all rows. How to join it?
This effect I just expected! Excellent. Why does this query work that way? I do not know the expression OUTER. I knew only that it is the query LEFT JOIN. What is the difference between these queries? Thanks