I am trying to use the following to retrieve everything in a column from a table that I do not know the name but can refernce if using an id, but I am getting an error
select * FROM
(select fldtable from tblQuestions where QuesID = '12')
the above should result in "select * from tbltest"
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near ','.
What am I doing wrong?