Christophe Leske <[EMAIL PROTECTED]> writes: > > 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? > Not as simple as you might think ... what is the structure of your tables c1, c2, c3 ... ? Do they have different columns in them, apart from foo1 ?
What are you trying to achieve, in terms of output rows and columns ? It might be clearer if you actually specify the output columns. If you do "select * from c1,c2,c3...." as it is, you will just generate all possible combinations of rows from the tables - not really what you want ! Regards, MikeW _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
