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