Re: Select query not working as expected

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 < shravya.neth...@aline-consulting.com>: > Hi, > > I am trying to select same city_id value for all the rows in "person" > table, using

Select query not working as expected

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: [cid:8255bcba-f678-4814-9