Ukoliko želiš dobiti ovako nešto:
IME |TABELA
----------
Pera|tabela1
----------
Pera|tabela2
Pera|tabela2
Firebird 2.0:
Code:
create table TABELA_1 (
ime varchar(30),
broj_1 integer,
broj_2 integer
);
create table TABELA_2 (
ime varchar(30),
broj_1 integer,
broj_2 integer
);
insert into TABELA_1 values ('Pera', 1, 1);
insert into TABELA_1 values ('Djoka', 1, 2);
insert into TABELA_1 values ('Mika', 1, 3);
insert into TABELA_2 values ('Pera', 1, 1);
insert into TABELA_2 values ('Djoka', 1, 2);
insert into TABELA_2 values ('Mika', 1, 3);
insert into TABELA_2 values ('Pera', 1, 4);
Upit:
Code:
select ime, 'tabela1' as tabela
from tabela_1
where ime = 'Pera'
union all
select cast('---' as varchar(30)),
cast('---' as varchar(7))
from rdb$database
union all
select ime, 'tabela2'
from tabela_2
where ime = 'Pera'
Rezultat:
Edit: upotrebio sam
cast, ispravnije je.
[Ovu poruku je menjao Miloš Baić dana 07.11.2007. u 12:51 GMT+1]
Someone's sitting in the shade today because someone planted a tree a long time ago.