ZliSin ZliSin - 26 days ago 6
Android Question

Multiple tables query android

I have three tables

Article Group Code
-------- -------- --------
id id id
Name GroupName CodeName
NameInfo Group value code value
Bla
bla
groupname
codename
something
bla


Can you please tell me how to make table so that I can see in my first table named articles values groupname and codename from another table? And then how to make select query?

Answer

You should create relational database structure,

enter image description here

select * from Article a 
inner join Group g on  (a.groupid = g.groupid)
inner join Code c on (a.codeid = c.codeid)