Ganesh Ganesh - 2 months ago 9
Android Question

How to write a query in SQLite for Android?

I am working on Android SQLite databses and my requirement is to get the data from two tables. The tables are status and diners.

Status Table:

enter image description here

Diners Table:

enter image description here

My intention is to get the data of color_desc from status table when the din-status_color column value from diners table and color_status-id column value from status table are equal.

How to write the query in Android SQLite?

Answer Source

Here an full tutorial it is help in the bast i hope help u too.

Good tutorial

and this one for beginners