i have to tables
assets and districts
and 2 commands
select district_id, name, city from assets where id = 10;
and i need
select name from districts where id = district_id;
I WANT 1 Command, i want to avoid to need another command to get the name of the district_id
this simple project should be possible without access to databse.