Skip to Content
Former Member
Jul 31, 2008 at 06:42 PM

select statement



i m facing a very simple issue...just want to confirm if my understanding is right...

select single a b into x y from table where m = n.

ny problem with this statement ??

can't i select the needed fields and move them to local variable of my choice with such a single select statement ??.

it does not work..keeps on giving syntax error...saying y is not expected !! any help ?