I'm new to Pervasive SQL but I have been using MS SQL 7 and 2000 for 5 years now. I have a problem. I can't make this SELECT work:

SELECT a.id FROM
( SELECT id FROM TABLE1) a

How to make it work?

Thanks in advance.