one database with multiple tables

I have a database file that has multiple tables. How do I search on all the tables. I've tested it only works for a table. Code:

 cu = myDB.rawQuery("select * from TABLE_A or Table_B ...  where " + field + " Like '%" + word + "%' group by " + field, null);