Hvala Dejan! Ko bo zagovor mimo te obvestim kako je blo s tem...
zanima me pa še, če ve kdo recimo na temle primeru razložit "not exists":
Prečitaj ime mesta (X);
poišči šifre delov, ki jih kupujejo vsi projekti v mestu X!
SELECT DISTINCT P#
FROM SPJ SPJ1
WHERE NOT EXISTS (
SELECT J#
FROM J
WHERE J.CITY='&X'
MINUS
SELECT DISTINCT J#
FROM SPJ
WHERE SPJ.P# =SPJ1.P#)
Zanima me predvsem, kaj dela tisti SPJ1 v vgnezdenem selectu, kar pa je
verjetno tudi povezano z "not exists"?!? (btw. to je 4.primer iz 3.vaje)
Hvala!
On 2/1/06, Dejan Veternik <[EMAIL PROTECTED]> wrote:
>
> Ko kreiras logicni model kliknes na vsako povezavo in na jezicek
> "Integrity", tu pa potem dolocis kaj se zgodi ce spremenis/izbrises kake
> kljuce ki so hkrati tuji ključi v kaki drugi tabeli... Mislim da je to to,
> me pa to vse se caka tko da bi bil vesel kake potrditve:)
>
> Lp,
> dejan
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jernej
> Vrcko
> Sent: Tuesday, January 31, 2006 11:53 PM
> To: FRIClist
> Subject: [Friclist] SEMINARSKA PB
>
> A mi lahko kdo pove kaj je to "opredeliti referencialne omejitve"!?
> Hvala!
>
> --
> J.
>
> ...If you think that things that you are doing are unimportant,
> be aware of importance of doing them.
>
> __________ NOD32 1.1389 (20060131) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>
>
>
--
J.
...If you think that things that you are doing are unimportant,
be aware of importance of doing them.
