"Christophe Leske" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > pardon me if this is a pretty easy SQL question, yet i am after a > statement compound which applies just ONE where clause to a group of > tables. > > Something like > > select * from c1,c2,c3.... where foo1<10
Perhaps something like this: select * from (select * from c1 union all select * from c2 union all select * from c3 ... ) where foo1 < 10; Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
