Re: [firebase-br] Diferenças entre left outer join e left join

[Fernando Reis Guimarães]

PRA NÃO FAZER QUE NAO FIZ TESTES
AI VAI..

/******************************************************************************/
/****         Generated by IBExpert 2006.10.14 26/11/2006 18:52:53
****/
/******************************************************************************/

SET SQL DIALECT 3;

SET NAMES ISO8859_1;

CREATE DATABASE '127.0.0.1:D:\GLOBAL\Banco de
dados\firebird\Employee\Employee.fdb'
USER 'SYSDBA' PASSWORD 'MASTERKEY'
PAGE_SIZE 4096
DEFAULT CHARACTER SET ISO8859_1;



/******************************************************************************/
/****                                Tables
****/
/******************************************************************************/



CREATE TABLE L (
    ID    INTEGER NOT NULL,
    NOME  VARCHAR(10)
);


CREATE TABLE R (
    ID        INTEGER,
    TELEFONE  INTEGER
);


INSERT INTO L (ID, NOME) VALUES (1, 'A');
INSERT INTO L (ID, NOME) VALUES (2, 'B');
INSERT INTO L (ID, NOME) VALUES (3, 'C');

COMMIT WORK;

INSERT INTO R (ID, TELEFONE) VALUES (1, 10101);

COMMIT WORK;



/******************************************************************************/
/****                             Primary Keys
****/
/******************************************************************************/

ALTER TABLE L ADD CONSTRAINT PK_L PRIMARY KEY (ID);


/******************************************************************************/
/****                             Foreign Keys
****/
/******************************************************************************/

ALTER TABLE R ADD CONSTRAINT FK_R_1 FOREIGN KEY (ID) REFERENCES L (ID);













SQLs:
SELECT *
FROM L LEFT OUTER JOIN R ON L.ID = R.ID


SELECT *
FROM L LEFT JOIN R ON L.ID = R.ID


Aqui pra mim o resultado das duas foi igual...
Atenciosamente,
Fernando Reis Guimarães.

Contatos
fernando em fernandobhz.com
http://www.fernandobhz.com
Celular 9213-3727.