Hello, You can define a "merge table" and run your select on it. Check the manual for details: http://www.mysql.com/doc/en/MERGE.html
Regards Joseph Bueno 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