android - Selecting from two tables -
i have following query in android query = "select docid _id," + key_id + "," + key_name + "," + " " + filter + " " + key_search + " match '" + txt + "';"; it selects the table depend on filter what wanna have filter "all" select 2 tables 1 query how can ? thanks please using preparedstatements ( http://docs.oracle.com/javase/tutorial/jdbc/basics/prepared.html ). inlining variables way allow sql injections. to answer question, use inner join (implicit or explicit).