Hello to all. I have 2 tables:

Avto:

ID ID_driver 1 23 2 32

Driver

 ID_driver Name Surname 23 Misha Volkov 32 Valera Petrov

How can I request the driver's name and surname in one field at once to get the following when outputting in the Avto table

 ID Name_Driver 1 Misha Volkov 2 Valera Petrov

Now I have such a request, but it displays in different fields.

 SELECT A.*, DR.NAME AS NAME, DR.SURNAME AS SURNAME FROM Avto A INNER JOIN DRIVER DR ON A.ID_Driver = DR.ID

It turns out that's

 ID ID_driver Name Surname 1 23 Misha Volkov 2 32 Valera Petrov

    1 answer 1

    interbase / firebird response: select char_field1 || ' ' || char_field2 select char_field1 || ' ' || char_field2 select char_field1 || ' ' || char_field2 (google with half a ping with the correct name of the database.)

    Initially tags were put in mysql / sql so the answer about mysql will be left for the story:

    google://mysql concat and, in principle, when you want to put something together / add lines (in any language, even mysql, even python), google concat+mysql , concat python , and then ask the question here. it will be good form

    As an exercise, you can fix this solution:

     SELECT A.*, CONCAT(DR.NAME, '%', DR.SURNAME) as driverName FROM Avto A INNER JOIN DRIVER DR ON A.ID_Driver = DR.ID

    and please, if you do not think about yourself, think about others, do not write the names of the tables and fields of the CAPSOM. CAPSOM should write SQL statements. Otherwise, someone, when debugging your queries without syntax highlighting (and with it too), will curse you with a black word.

    PS please specify the database, because you have removed the mysql tag

     mysql> use db; Database changed mysql> mysql> create table driver (name text, surname text); Query OK, 0 rows affected (0.22 sec) mysql> insert into driver values ('vanya', 'petrov'); Query OK, 1 row affected (0.03 sec) mysql> select concat(name, surname) from driver; +-----------------------+ | concat(name, surname) | +-----------------------+ | vanyapetrov | +-----------------------+ 1 row in set (0.00 sec) mysql> select concat(name, surname) as kek from driver; +-------------+ | kek | +-------------+ | vanyapetrov | +-------------+

    author can be forgiven only because he does not know about the existence of a heap of SQL dialects

    • Writes that unknown function. I'm doing in the embarcadero) - Mr.Steps
    • so it is also not mysql? - strangeqargo pm
    • Yes, I forgot to say or remove the tag :) - Mr.Steps
    • one
      Can you then google and tag the correct tag? - strangeqargo
    • Has long put the right tag, cat. was also originally - Mr.Steps