create table table1 (
code int, name varchar(64), adress varchar(64), rik varchar(64), plz varchar(64), plj varchar(64), prim varchar(64)
);
insert into table1 values
(1, 'ΠΠ²Π°Π½ΠΎΠ² ΠΠ', 'ΠΏΡ.ΠΠ΅ΡΠ΅ΠΌΠΎΠ³ΠΈ, 2-13-45', '21.12.2021', '120', '95', 'ΡΡΡ ΠΏΡΠΈΠΌΡΡΠΊΠ°'),
(2, 'ΠΠ΅ΡΡΠΎΠ² ΠΠ', ' Π²ΡΠ». ΠΡΠΎΠΏΠΈΠ²Π½ΠΈΡΡΠΊΠΎΠ³ΠΎ 34 -56-78', '02.12.2021', '250', '125', 'ΠΏΡΠΈΠΌΡΡΠΊΠ° ΠΎΡΠ½ΠΎΠ²Π°Π½Π° Π½Π° Π΄Π΅ΡΠΊΠΈΡ
Π΄Π°Π½ΠΈΡ
'),
(3, 'Π‘ΠΈΠ΄ΠΎΡΠΎΠ² ΠΠ', ' Π²ΡΠ». ΠΠ°ΡΡΠΈΠ·Π°Π½ΡΡΠΊΠ° 23 ΠΊΠ²Π°ΡΠΈΡΠ° 43', '04.12.2021', '45', '34', '');
select * from table1;
create table table2 (
code int, id1 int, litera varchar(64), name varchar(64), rzp int, rjp int
);
insert into table2 values
(1, 1, 'Π1Π°1', 'Π±ΡΠ΄ΠΈΠ½ΠΎΠΊ', 120, 95),
(2, 1, 'Π', 'ΡΠ°ΡΠ°ΠΉ', 0, 0),
(3, 1, 'Π', 'ΠΏΠΎΠ³ΡΡΠ±', 0, 0),
(4, 2, 'Π1Π°1Π°2', 'ΠΆΠΈΡΠ»ΠΎΠ²ΠΈΠΉ Π±ΡΠ΄ΠΈΠ½ΠΎΠΊ', 250, 125),
(5, 2, 'Π', 'Π»ΡΡΠ½Ρ ΠΊΡΡ
Π½Ρ', 0, 0),
(6, 2, 'Π', 'Π³Π°Π½ΠΎΠΊ', 0, 0),
(7, 3, 'Π1', 'ΠΆΠΈΡΠ»ΠΎΠ²ΠΈΠΉ Π±ΡΠ΄ΠΈΠ½ΠΎΠΊ', 45, 34),
(8, 3, 'Π', 'ΡΠ°ΡΠ°ΠΉ', 0, 0);
select *
from table1
left join table2 on table1.code = table2.id1
where table1.code = 1;
Telegram: DB developers channel