> I must admit, I don't know all the ANSI standards for SQL-SELECT's and if > you say FOX's implementation is weak, then I must take your word for it. > That being the case, you probably have a good point. I know that > improvements were made for 5.0, but apparently not enough. Four examples come immediately to mind, I'd have to check my notes for others: 1) SELECTs that are nested greater than 2 2) More than a single UNION 3) UPDATE and DELETE that contain a SELECT 4) ORDER BY and GROUP BY on an expression, rather than just a fieldname or result column. /Paul