How to get the inner query's column as output in the select statement? Here the lang in users table needs to be returned by the select statement. Is it possible with this query?
SELECT ID, LANG -- THIS LANG IS NOT WORKING
INTO V_TRAVEL_ID, V_LANG
FROM TRAVEL_TABLE
WHERE USER_ID = (SELECT MYID, LANG -- this LANG column needs to be returned from the query
FROM USERS
WHERE CONTACT_ID = V_CONTACT_ID);