«« ( Date ) »» // «« ( Thread ) »» // nastava - 2003

Re: Resenje Problema iz baza

by Damjan S. Vujnovic
subota, 01. mart 2003 - 20:18.

SQL:

SELECT DISTINCT T1.AUTOR
FROM Table1 AS T1, Table1 AS T2
WHERE T1.AUTOR
Proveri pa mi javi !!

Valjda:

SELECT DISTINCT T1.Autor AS Autor
FROM Table1 AS T1, Table1 AS T2
WHERE T1.Autor=T2.Autor
AND NOT(T1.Naslov=T2.Naslov)

Pozdrav,
Damjan S. Vujnović