Can't tell what EngineBehaviour is set in ADO because I can't find a way of returning the value from a commands output. However I have tested all three EngineBehaviours in native VFP9 (SP1) and the bracketed subquery union works fine with all of them.