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 votes167 views1 answer
Mysql shell insert into
SQL
11 votes317 views4 answers
Round in sql
SQL
0 vote140 views1 answer
Display first three characters sql
SQL
31 votes134 views1 answer
Postgresql add column with constraint
SQL
0 vote133 views1 answer
Sql string length postgresql
SQL
8 votes153 views1 answer
Show mysql user table
SQL
1 vote133 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote145 views2 answers
Mysql dump database tables only
SQL
15 votes282 views2 answers
Sql order by alphabetical
SQL
2 votes172 views1 answer
Oracle insert or update
SQL