There are 4 tables. There is no numeric id in the Country table. Country Code - key type Char. Scheme and sample query in Visual Studio

It is necessary to assign a numeric value to each row of the Country table in the query, so that the following sample is obtained as a result of the query:
FirstName LastName CounryName CountryRowNumber
Novikov Vasily Russia 1
Ivanov Sergey Russia 1
Jonh Smith USA 2 Ann Smith USA 2
Additional columns in the database can not be created!

  • Tell me, this is just a problem, right? won't it be used in a real project? .. - Alexander Belinsky
  • If this is just an educational task - you can try to adapt this monster to your task. If this is a real project, find a way to create a column. - Alexander Belinsky

0