I do independent work on databases. They said that instead of keys, the values ​​of these keys should be displayed. Now the question. enter image description here

There is such a database. There is a table Orders and Record. In the Orders table, the Entry Code column is associated with the Code column in the Entries table. What do you think should be output to the recording code? What value can there be in general, so that the user can understand everything? PS Bd was a teacher.

    1 answer 1

    From the table Запись to take nothing special except the date, but this is clearly not what is needed. Most likely, follow the song code and take its name from the Архив песен table. Sample SQL query:

     SELECT [Заказы].*, [Архив песен].[Название] FROM [Заказы] JOIN [Запись] ON [Заказы].[Код записи] = [Запись].[Код] JOIN [Архив песен] ON [Запись].[Код песни] = [Архив песен].[Код]
    • Can visual studio do this? - Andrei
    • @Andrey, Well, of course, only SQL is desirable to implement such things. - Klym Nov.
    • I just know how to display the value with linked tables, but how not through a table - no. - Andrei
    • @Andrey, well, here, too, the connection is no different, just a double JOIN will be. - Klym Nov.
    • I tried to simply change the type of the Code column on the comboBox and output it from the table. Archive of songs. But an error is displayed that the value is invalid. - Andrei