Zeoslib Portal

Code: Select all

SELECT
    LINGUE_PC."Arrivo",
    PREVHDR."Arrivo"
  FROM
    PREVHDR INNER JOIN
    LINGUE_PC ON (PREVHDR."Lingua" = LINGUE_PC."Codice")

Code: Select all

SELECT
    PREVHDR."Arrivo",
    LINGUE_PC."Arrivo"
  FROM
    PREVHDR INNER JOIN
    LINGUE_PC ON (PREVHDR."Lingua" = LINGUE_PC."Codice")

Code: Select all

CREATE VIEW TEST_VIEW(
  "Arrivo",
  "Arrivo1")
AS
SELECT
    PREVHDR."Arrivo",
    LINGUE_PC."Arrivo"
  FROM
    PREVHDR INNER JOIN
    LINGUE_PC ON (PREVHDR."Lingua" = LINGUE_PC."Codice");

Code: Select all

SELECT * FROM TEST_VIEW

Code: Select all

SELECT
    PREVHDR."Arrivo" AS PH_Arrivo,
    LINGUE_PC."Arrivo" AS LPC_Arrivo
  FROM
    PREVHDR INNER JOIN
    LINGUE_PC ON (PREVHDR."Lingua" = LINGUE_PC."Codice")

Code: Select all

/* SQL Manager Lite for InterBase and Firebird 5.5.1.50223 */
/* ------------------------------------------------------- */
/* Host     : localhost                                    */
/* Database : C:\TEST\TESTDB.FDB                           */

CREATE DATABASE 'localhost/3050:C:\TEST\TESTDB.FDB'
  USER 'SYSDBA'
  PAGE_SIZE = 4096
  DEFAULT CHARACTER SET ISO8859_1
  COLLATION ISO8859_1;

/* Structure for the `T1` table :  */

CREATE TABLE T1 (
  T1_ID INTEGER NOT NULL,
  "Same_Name_Field" DATE NOT NULL);

ALTER TABLE T1 ADD PRIMARY KEY (T1_ID) USING INDEX RDB$PRIMARY2;

/* Structure for the `T2` table :  */

CREATE TABLE T2 (
  T2_ID INTEGER NOT NULL,
  "Same_Name_Field" VARCHAR(20),
  ID INTEGER);

ALTER TABLE T2 ADD PRIMARY KEY (T2_ID) USING INDEX RDB$PRIMARY3;

/* Privileges for the `T1` :  */

GRANT SELECT, INSERT, DELETE, REFERENCES, UPDATE ON T1 TO SYSDBA WITH GRANT OPTION;

/* Privileges for the `T2` :  */

GRANT SELECT, INSERT, DELETE, REFERENCES, UPDATE ON T2 TO SYSDBA WITH GRANT OPTION;

Code: Select all

SELECT
  T1."Same_Name_Field",
  T2."Same_Name_Field"
FROM
  T1 INNER JOIN
  T2 ON (T1.T1_ID = T2.ID)

Code: Select all

SELECT
  T1."Same_Name_Field" AS T1_Same,
  T2."Same_Name_Field" AS T2_Same
FROM
  T1 INNER JOIN
  T2 ON (T1.T1_ID = T2.ID)

Code: Select all

SELECT
  T2."Same_Name_Field",
  T1."Same_Name_Field"
FROM
  T1 INNER JOIN
  T2 ON (T1.T1_ID = T2.ID)