sorry for bringing this back, but I wanted to send the answer for anyone who may be interested:

There are two cases:

case1:

when you return a single row from a table:...