Thanks Joseph and Kelly. I think "merge tables" will be a good solution for me.
Veysel Harun Sahin wrote: > Hello, > > I have a problem with select statetement. I need to query and select > records from multiple tables which have the same column types. I have > done this with left join but my query became so complex. Because i > have written "left join" between all of my tables and also if i need > to query something i have to write "tablename.columnname" syntax for > each table. Now i am looking for a more basic query to be able to do > this. For example i have 3 tables with the names of "table1", "table2" > and "table3". All of my tables have 2 columns "cola" and "colb". I > have to select records whose "cola = something" from all of my tables > with one query. > > Thanks. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php