Values from 2 tables in one column

[kfleming]

Try adding some extra ()^s to force the order of evaluation:____TABLE01->FIELD01 is equal to ParameteRR01 __or (TABLE02->FIELD02 is equal to ParameteRR02 __and (TABLE02->FIELD03 is equal to _KE*_ __or TABLE02->FIELD03 is equal to _KS*_))____This will OR the table1 condition with the table2 condition where the table2 condition first OR^s the two field3 condition and then ands the result with tha parameter comparison.__So there are two sets of extra parentheses that are added.____As long as there are records in each scan that meet the condition it should work.____Kathleen __R&R Support__

[happydermis]

Thanks Kathleen,____I am still working on finding the right query. I will keep you informed :-)____Dekers

[happydermis]

Well, the solution was not that difficult (as usually...)____TABLE01->FIELD01 is equal to ParameteRR01__or (TABLE02->FIELD02 is equal to ParameteRR02__and TABLE02->FIELD03 is in the list "KE*","KS*")____I simply used "in the list" instead of two separate queries____Thanks for the support, Dekers