CREATE TABLE `baza2` (
`imie2` text NOT NULL,
`nezwisko2` text NOT NULL,
`wiek2` int(11) NOT NULL,
`data2` date NOT NULL,
`id2` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Zrzut danych tabeli `baza2`
--
INSERT INTO `baza2` (`imie2`, `nezwisko2`, `wiek2`, `data2`, `id2`) VALUES
('Piotrek', 'Grzejnik', 69, '2012-12-13', 1),
('ELO', 'Melo', 12, '2003-12-13', 2);
CREATE TABLE `baza` (
`imie` text NOT NULL,
`nazwisko` text NOT NULL,
`wiek` int(11) NOT NULL,
`data` date NOT NULL,
`id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Zrzut danych tabeli `baza`
--
INSERT INTO `baza` (`imie`, `nazwisko`, `wiek`, `data`, `id`) VALUES
('Daniel', 'Dupa', 12, '2019-03-13', 1),
('Piotrek', 'Grzejnik', 69, '2012-12-15', 2);
`baza` OUTER JOIN `baza2`
ON baza.imie=baza2.imie2, baza.nazwisko=baza2.nezwisko2 , baza.wiek=baza2.wiek2 , baza.data=baza2.data2 baza.id=baza2.id2
SELECT * FROM `baza`, `baza2` WHERE baza.id=baza2.id2
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}