Re: ACESS FOREIGN KEY TABLE

2020-03-14 Thread Sunday Iyanu Ajayi
How are you querying it? Is it from python script or database query? If it is a SQL database like postgres, you can join the two tables using the "JOIN" syntax . You join the two tables using their ids *SELECT ** *FROM profile p* *JOIN skill s ON s.user_profile = p.id * NB: You can c

ACESS FOREIGN KEY TABLE

2020-03-12 Thread Soumen Khatua
Hi Folks, My profile model is Foreignkey in another model called Skill,Now I fetch all the data of this user from Profile table(model) and store it into a variable called user_profile and now my query is I want to fetch the data of the Skill table(model) by using this variable.How I can do that??