Hello! Are you actually sure that city_id is not null for this row of city table?
Regards, -- Ilya Kasnacheev чт, 28 нояб. 2019 г. в 15:47, Shravya Nethula < [email protected]>: > Hi, > > I am trying to select same city_id value for all the rows in "person" > table, using the following query: > *SELECT id, name, age, (SELECT city_id FROM city WHERE id=1001) AS cityId > FROM person * > But it is not giving results as expected. Please find the screenshot below: > > > > Is the select query wrong? > Is there any syntax error? > Or is there any other way in which I can achieve this? > > > > > Regards, > > Shravya Nethula, > > BigData Developer, > > > Hyderabad. > >
