sql - can i decide the column names of a SELECT statement from another SELECT statement -

Can I decide the column names of a selection statement from the second selection statement

this way From:

  SELECT (SELECT SELECTSTMTA to aID = b.ID where a.ID = 300019) to C. WHERE lkpgroup = 300019  

< P>

You can either explicitly request the All column or clear column , Like)

Select ColA from Column 1, ColB

Your query will fail because your saying "Select (subkey)". You need to select 'some' and use the keyword to .

I recommend that you make a column call in your subquery, then use the select * to return to the entire dataset of your subquery. EG)

  from query SELECT * (query a.ID = a bonus on b.id. B) where the query query. Cola = 300019  

So to answer your question, no. You can not use a specific query to decide which column you return. - It would be like to say a compiler to write a program!

However, you will use * to return all the columns from the subcategory, table or view.