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

1 vote247 views1 answer
User privileges postgresql information_schema
SQL
41 votes327 views6 answers
Alter table add column in SQL Server
SQL
0 vote248 views1 answer
Postgres full text search example
SQL
0 vote258 views1 answer
What alter does in db
SQL
0 vote259 views4 answers
Change schema in sql server
SQL
2 votes259 views1 answer
Date conversion in mysql column
SQL
0 vote255 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote245 views1 answer
Mysql select last 15 minutes
SQL
49 votes323 views6 answers
Install mysql ubuntu
SQL
0 vote267 views1 answer
Sql server convert to guid
SQL