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

2 votes372 views1 answer
Install postgresql centos 5
SQL
5 votes314 views1 answer
Find table from column name in sql
SQL
1 vote316 views1 answer
Pentaho + pasar de excel a sql
SQL
0 vote358 views1 answer
CONVERT time string into 12 hours in sql
SQL
2 votes322 views1 answer
How to create sql database
SQL
0 vote306 views1 answer
Mysql_num_fields in mysqli
SQL
36 votes337 views3 answers
Add column in mysq
SQL
0 vote297 views1 answer
Remove from table where
SQL
1 vote294 views1 answer
Autocommit mysql
SQL
3 votes335 views1 answer
Sql add two values together
SQL