Hi
I am trying to do a select like that above where
I want to select rows that match the columns and values
exactly.

so for example I want to do this:

select * from people
where (('name','age') in (('dan',30),('eric',40))


to get the 2 people who have the name and age pair matching ('dan',30) and ('eric',40).

this sql runs fine in mysql but not in pervasiveSQL.
Is this not possible? Am I missing something?

~ Daniel