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-91e7-7b32c510a607] 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, [cid:58267690-e75f-4ea8-b011-dcc384a7f010] Hyderabad.
