android - Implement a Favourites feature using SQLITE -

i want implement favourites feature in app user can store items in favourites table.

i have table called recipes 5 fields - id,name,summary,ingredients , directions have table called faves 2 fields - id , favs_id.

i upto hear far. how go implementing favourites moving forward. tutorial link help.

what looking simple group by query can achieve.

in here favorites display first , rest .

hope helps

go this..

select * recipes inner join faves on recipes.fields_id=faves.fields_id group faves.fields_id 

haven't tested sure idea.