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 vote170 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote106 views1 answer
Hangfire clean script
SQL
4 votes265 views1 answer
Oracle table statistics
SQL
0 vote147 views1 answer
Laravel migration sql dump
SQL
3 votes143 views1 answer
Locate sql server
SQL
0 vote640 views1 answer
Sql show table name in result
SQL
0 vote149 views1 answer
Oracle list user locked
SQL
1 vote200 views1 answer
Mysql stop password policy
SQL
6 votes145 views4 answers
Remove spaces sql server
SQL
0 vote159 views1 answer
Synapse sql table set pk
SQL