Android sqlite select statement does not work well

view story

http://stackoverflow.com – I've got three table and i want make a query withe sql statement, but it does not work well because it does not give me all the possible results... The code: public void setsuchresultat(String pSearchword) { String[] table = new String[]{"tbl_A", "tbl_B", "tbl_C"}; String[] column = new String[]{"columnA", "columnB" }; // Type varchar(50) not null String[] search = new String[]{"%" + pSearchword+ "%", pSearchword+ "%", "%" + pSearchword, pSearchword}; getdata(table,column,search); } public void getdata(String[] pTable, String[] pColumn, String[] pSearch) { for(Str (HowTos)