MYSQL Nested Query with two select <p>I have:</p> <pre><code>Table1 (UserID -City - Adress - Mobile) Table2 (DeviceID - UserID - Vendor - Model). </code></pre> <p>I want to perform nested query to select the following in one row:</p> <pre><code> select DeviceID, UserID, Model From Table2 Where Vendor=Sony (and for this row go and select City - Address - Mobile from table 1 where table1.UserID = Table2.UserID) </code></pre> <p>How can I perfom the second select in the same query to be printed in the same row after Model.</p>