Subselect queries

Are these possible in mySQL or only in something like SQL...

And is it quicker to make a couple of simple queries or to try and make one more complicated query that does several things at once?

Re : Subselect queries

How can we use code to join two names first and second name to display Fullname