Raw query must include primary key

queryset=country_model.objects.raw('SELECT myapp_country_model.cname,myapp_state_model.sname FROM myapp_country_model INNER JOIN myapp_state_model on myapp_country_model.id=myapp_state_model.cid_id')
Solution
queryset=country_model.objects.raw('SELECT myapp_country_model.id,myapp_country_model.cname,myapp_state_model.sname FROM myapp_country_model INNER JOIN myapp_state_model on myapp_country_model.id=myapp_state_model.cid_id ')

Similar codes

0 vote197 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote217 views2 answers
Sql stored procedure for access frontend
SQL
1 vote233 views1 answer
Mysql search like order by best match
SQL
1 vote188 views1 answer
Scaffold mysql database
SQL
0 vote221 views1 answer
Query builder doctrien return sql
SQL
26 votes450 views6 answers
Modify column name in sql
SQL
0 vote248 views1 answer
Oracle sql date winter time
SQL
9 votes222 views6 answers
Check constraint in sql
SQL
0 vote267 views1 answer
Mariadb disable foreign key checks
SQL
0 vote197 views1 answer
Mysql set column equal to another automatic
SQL