this is my problem:

I have a result of a SELECT that show me some value like first name and last name of a user.

Example:  

Firstname = "First"  

Lastname = "Last"  

Now I want to get another value that is the result of another select (SELECT \* FROM x WHERE y = z)  

Example:  

Firstname = "First"  

Lastname = "Last"  

**NewValue** = "true" (or false)  

How can I do this?