Dotaz: asi hloupy sql dotaz

[stradivarius]

zdravim, mam takovy.. no.. asi dotaz. Mam Postgresql 8.0 a v nem 2 tabulky, dejme tomu

tabulka prvni:

CREATE TABLE ci_citation
(
  date varchar(20) NOT NULL,
  idcitation bigserial NOT NULL,
  identifier int8
  CONSTRAINT fk_citation_identifier FOREIGN KEY (identifier) REFERENCES md_identifier (code) ON UPDATE NO ACTION ON DELETE NO ACTION
}

tabulka druha:

CREATE TABLE md_identifier
(
  authority int8,
  code bigserial NOT NULL,
  CONSTRAINT pk_identifier PRIMARY KEY (code),
  CONSTRAINT fk_identifier_citation FOREIGN KEY (authority) REFERENCES ci_citation (idcitation) ON UPDATE NO ACTION ON DELETE NO ACTION
) 

tak a ted bych potreboval vybrat pokazde z obou tabulek ci_citation.idcitation,ci_citation.date a md_identifier.authority, i kdyz muze byt pole ci_citation.identifier null. Potrebuji to v jednom selectu, tedy aby vratilo vsechny 3 pole, authority a identifier samozrejme prazdne. Musim si na to napsat nejakou sql/plpgsql funkci nebo to jde nejak jednoduse obejit?

Mozna to sem uplne nepatri, prosim nekamenujte me. Diky.

Odpovědi

[zabza]

select * from ci_citation left outer join md_identifier on identifier = code

asi...

[stradivarius]

nojo. ivoku, dekuji ti za rychlost a presnost.

[zabza]

Jojo, OUTER JOIN je většinou prima věc ...