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).


Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -