hi .. let's say i have a table and a variable.
SELECT email from parent where username = @pusername;
will return the value that i need to have in @mail variable..
how can i set the @mail variable to get the value of the above sql query ? i also know that it will return only one result .
thanks in advance