So basically I am trying to get this half name by running
SELECT subName FROM table_1 WHERE condition
And the result of this would be used in a second query to search for something in the specific table, for example
SELECT TOP 1 * FROM fullTableName ORDER BY someColumn
So by joining the 2 together and assumin the other half of the column name is static I am trying to do this
'SELECT TOP 1 * FROM 'staticName' + (SELECT subName FROM table_1 WHERE someCondition) ORDER BY someColumn
But php keeps giving me
Expand|Select|Wrap|Line Numbers
- Description: Incorrect syntax near 'staticName'.
Best Regards
NooK