SELECT * FROM lowisko INNER JOIN ryby ON lowisko.Ryby_id = ryby.id; SELECT * FROM lowisko LEFT JOIN ryby ON lowisko.Ryby_id = ryby.id; SELECT * FROM lowisko RIGHT JOIN ryby ON lowisko.Ryby_id = ryby.id; SELECT * FROM lowisko CROSS JOIN ryby; SELECT * FROM lowisko AS b1 INNER JOIN lowisko as b2 ON b1.id = b2.Ryby_id;