Gia HARD SQL users

[CHRIS_MALL]

Ypothetoume pws exoume tous 3 parakatw pinakes :

CD

-----

code

title

 

 

CD_ENTRY

----------

CD

song

 

SONG

--------

Code

title

 

Diladi o CD_ENTRY exei:

CD SONG

1 1

1 2

1 3

2 2

2 4

3 5

 

Kai thelw na dimiourgisw me SQL ena erwtima (Access) pou tha mou emfanizei tous titlous twn cd twn opoiwn ena toylaxiston tragoudi tous den periexetai se allo cd, exoun diladi 1 tragoudi toulaxiston se apokleistikotita.

Kamia idea?

[lefterhs]

SELECT CD_Entry.song, First(CD.title)

FROM CD INNER JOIN CD_Entry ON CD.Code = CD_Entry.CD

GROUP BY CD_Entry.song

HAVING Count(CD_Entry.song)=1;