I have the following raw SQL statement, but i do NOT want to use an sql.rawquery I want to know how to do this in an SQL.Query statement form for android.
String NewSqlstatement =
"SELECT "+
"LOCATIONS_TABLE.LocationWebsiteID, "+
"LOCATIONS_TABLE.locationCity, "+
"LOCATIONS_TABLE.locationState, "+
"LOCATIONS_TABLE.locationCountry, "+
"LOCATIONS_TABLE.locationUrl, "+
"LOCATIONS_TABLE.LocationID, "+
"PREF_TABLE.Pref_SavedTitle, "+
"WEBSITECATEGORY_TABLE.WBLinkTitle, "+
"WEBSITECATEGORY_TABLE.WBLinkURL "+
"FROM "+
"PREF_TABLE "+
"INNER JOIN "+
"LOCATIONS_TABLE "+
"ON "+
"PREF_TABLE.Pref_LocationID = LOCATIONS_TABLE.LocationID "+
"INNER JOIN "+
"WEBSITECATEGORY_TABLE "+
"ON "+
"WEBSITECATEGORY_TABLE.WBLinkWebsiteID = PREF_TABLE.Pref_WebsiteID "+
"WHERE "+
"PREF_TABLE.Pref_SavedTitle = '?'";
Aucun commentaire:
Enregistrer un commentaire