Home > database >  Help to have a big help to write the SQL
Help to have a big help to write the SQL

Time:09-20

T_assistant list id contains ta tam tad in three levels of the whole, the id
And the field name, city_id,
Relational tables and two ta t_assistant_district_manager_realtion is t_adid relationship with tam_id table
T_assistant_manager_assistant_realtion is t_amid and ta_id relational tables,
T_city table: id and t_assistant city_id corresponding
Need to query:
Ta_id
Ta_name
Tam_id
Tam_name
Tad_id
Tad_name
city_name

CodePudding user response:

Tad_id wrong into t_adid

CodePudding user response:

Technical problems in art of asking questions

CodePudding user response:

Can structure code, on, above, on the wrong, don't use language is introduced
  • Related