SELECT pepa.*,pepa2.* FROM `pepa_studovna_net`.`pepa` left join `pepa_studovna_net`.pepa2 on pepa.id=pepa2.id_pepa WHERE 1 and pepa.id = 2


idjmenoprijmeniukolnazevpopis
66 jarda smarda test nakup kose velky 50
67 jarda smarda test nakup kose1 velky 50 a salam
nezadane udaje pro vlozeni
SELECT * FROM `zamestnanci` WHERE 1 ;


rcjmenoadresaplat
211111/25 pepa lol 10000.00
201129/4986 Jan Novák Kocourkov 111 25000.00
201129/498 Jan Novák2 Kocourkov 1112 25000.00
Jan Novák2 Kocourkov 1112 25000.00
a Jan Novák2 Kocourkov 1112 25000.00
221568/4521 cau JANOVA2 25000.00
0220 cau JANOVA2 25000.00
221568/4 oooooh JANOVA2 25000.00
avs asd cas 25000.00
1548 ahoj smarda 25000.00
123 0.00
12 0.00
222 409281 dum 0.00
444 56 888 888.00
1 409281 dum 2002.00
2 165448 dum1 100.00
242 1.00
321 1.00
1231 100000.00
8888888 7663 Hehrgrzr 6688.00
158 pepa litencice 5000.00
Celkem349680.00