subqueries in sql (supported in tbs?)

i have a query like the following:

SELECT wid, photourl  FROM nex_firsttable WHERE wid =
(SELECT wid FROM nex_othertable WHERE userid=5)

this is an allowable mysql 4.1 and above query but i am getting an error back from tbs saying it is invalid syntax - does tbs support subqueries??

Hi,

TBS knows nothing of SQL. It simply passes the statement "as is" to MySQL.
I suggest you to test your query on a direct MySQL interface such as PhpMyAdmin.

I was not aware MySQL supported subqueries...
I'll test at home...

aha - i need mysql 4.1 to make subqueries - and that is not in final release yet (just alpha) - so that is the problem - i will have to use joins instead to get the behavior i want :( - thank you for a great templating lib by the way!