MYSQL Nested Query with two select

Question

I have:

Table1 (UserID -City - Adress - Mobile)
Table2 (DeviceID - UserID - Vendor - Model).

I want to perform nested query to select the following in one row:

 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)

How can I perfom the second select in the same query to be printed in the same row after Model.

ScaisEdge · Accepted Answer · 2016-06-12 12:27:26Z

1

Use inner JOIN

select 
      t2.DeviceID
    , t2.UserID
    , t2.Model
    , t1.city 
    , t1.Address
    , ti.mobile
From Table2 as t2
Where Vendor='Sony'
INNER JOIN table1 as t1 on  t1.UserID = t2.UserID

answered Jun 12, 2016 at 12:27

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MYSQL Nested Query with two select

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related