How can I get the value of a select query into a variable? For example, the result of this query "Select ID from table A" should be moved into variable X.
Also what is the syntax to write a sub-query. I tried the following and it does not seem to work.
"Select NAME from Table A where ID=( "Select AID from table B where SName like 'ABC' ")"