N
response for interbase/firebird: select char_field1 || ' ' || char_field2 (singing on the floor with the right name )Initially mysql/sql, so the answer about mysql will be left for history:google://mysql concatand, in principle, when you want something to connect/start lines (in any language, even mysql, at least python), googlet. concat+mysql♪ concat pythonAnd then ask the question here, it'll be a good tone.As an exercise, you may correct this decision: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 don't think about yourself, think about the others, don't write the names of the tables and fields of CAPSOM. SQL should be written by SQL operators. Otherwise, when you're going to deflect your enquiries without syntaxis lighting, too, will curse you with a black word.P.S., please clarify the database, because you removed the gate mysql.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 |
+-------------+
The author can only be forgiven because he has no knowledge of the existence of a bunch of SQL dialects.
