Forum Debian Users Gang

SELECT tab1.pol1, tab1,pol2, tab1,pol1a
  FROM tab1
  JOIN tab2 ON tab2.pol_laczace = tab1.pol_loaczace;

CREATE VIEW costam AS
SELECT tab1.pol1, tab1,pol2, tab1,pol1a 
  FROM tab1
  JOIN tab2 ON tab2.pol_laczace = tab1.pol_loaczace;

SELECT * FROM costam

SELECT * FROM tabela1 t1 INNER JOIN tabela2 t2 ON t1.id=t2.id

albo

SELECT * FROM tabela1 INNER JOIN tabela2 USING(id) ------>>powinno, aczkolwiek nie musi działać.

  SELECT *
      FROM o_foldery tab1
      INNER JOIN o_papier tab2 ON tab1.id = tab2.id

  SELECT *
      FROM o_foldery
      INNER JOIN o_papier ON o_foldery1.id = o_papier.id

SELECT id, user, realname
FROM o_foldery
INNER JOIN o_papier ON o_foldery1.id = o_papier.id