Hi, 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 with foo1 being in all of the specified tables. So far, all i can see is that I have to build several statements which all have the where clause in there. Isn´t there something more tersed? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
