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 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.