The ability to store row IDs inside a relational table extends the traditional relational model and enhances the
capacity of an object/relational database to establish relationships between tables. Pointer data types allow you to:

* Reference sets of related rows in other tables.
It is possible to violate first normal form and have a cell in a table that contains a pointer to repeating
table values. For example, an employee table could contain a pointer called job_history_set, which in turn contains
pointers to all the relevant rows in a job_history table. This would also allow for aggregate objects to be prebuilt
so that all the specific rows in the aggregate table could be predefined.
* Include pointers to nondatabase objects in a flat file.
For example, a table cell could contain a pointer to a flat file that contains an object such as a picture in
GIF or JPEG format.
* Establish pointers to repeating groups.
Database designers can violate first normal form and create a table column that has pointers to an array of row
pointers. For example, you might create a column called order_history in a customer table. The column could contain a
pointer to a reference table containing pointers to the specific rows that represent prior orders for that customer.
* Establish one-to-many and many-to-many data relationships without relational foreign keys.
This capability alleviates the need for relational JOIN operations, since table columns can contain references
to rows in other tables. By de-referencing these pointers, rows from other tables can be retrieved without ever using
the expensive SQL JOIN operator.

Brkic: @darko_sudarov
Napravio sam proceduru,ne izbacuje gresku,pogresio sam sa q.open i q.ExecSQL jer sam imao 'try except' ali napretka nema.Vreme izvrsavanja je isto,pomirio sam se da ne moze brze mada je smesno sa 6.000 rekorda,koliko ce vremena trebati sa 100.000 rekorda.

q.SQL.Clear;
q.SQL.Add('CREATE INDEX prom_ime on promene(ime)');
q.ExecSQL;

i jos jedno pitanje u veze selekcije
SELECT P1.ime,p1.br FROM ulaz P1 WHERE SINGULAR( SELECT ime,br FROM prom P2 WHERE P2.ime = P1.ime and p2.br<>p1.br)
radi OK,izbaci sve koji imaju razlicit 'br' ali trebalo bi mi i da izbaci vrednost p2.br za to ime, probavao sam drugacije ali ne ide,nece.

SELECT P1.ime,p1.br,p2.br FROM ulaz P1,p2 ...
znaci trebalo bi mi da izbaci ista imena sa razlicitim brojevima iz 2 tabele formata ime,br1,br2
moze li pomoc

Brkic: @schild nasao sam IBExpert personal i isti je kao i IBOConsole,bazu i tabele sam kreirao iz njega i isto je kao iz Delphi coda,e sada tu ima pitanja: sta je 'Domains' i 'Stored Procedures' ?? Video sam sa u primeru EMPLOYEE da vrednosti iz tabele veze sa vrednostim iz 'Domains'

sta znaci biti normalizovana , moze li neko dati neki primer kako treba napraviti bazu i tabele da bude normalizovano ,bilo bi od velike pomoci nego ovako nabadati sta ima sta nema sta je dobro sta nije, ako ima neko raspolozen da pomogne ?? ili neki PDF o bravljenju baza i tabela,podesavanja...

@schild, sto se tice upita,primer koji si dao je OK i to sam probavao ranije ali to nije resenje.
Resenje treba da izgleda ovako
tab1
-------
pera 10
dura 17
tito 8

tab2
-------
pera 15
dura 12
tito 8

resenje
-----------
pera 10 15
dura 17 12