Dear all, I'm a newbie, need your help. Now I am building a databasea using MySQL and PHP, I want to put two tables in one searching, the two are in one database. $query = "SELECT SQL_CALC_FOUND_ROWS * FROM table1 WHERE ".implode(" AND ", $data); $number = "SELECT FOUND_ROWS()"; How can I change this if I want to put table2 in it. Thank you. Best wishes, diana 2010-7-21