ÐÓÊÎÂÎÄÑÒÂÎ ÏÎ ÐÅËßÖÈÎÍÍÎÉ ÑÓÁÄ DB2

         

ÂÛÁÎÐÊÀ ÑÏÅÖÈÔÈÖÈÐÎÂÀÍÍÛÕ ÈÇ ÑÎÅÄÈÍÅÍÈß


Âûäàòü âñå êîìáèíàöèè íîìåðîâ ïîñòàâùèêîâ è íîìåðîâ äåòàëåé, òàêèõ, ÷òî ïîñòàâùèê è äåòàëü ñîðàçìåùåíû:

SELECT                S.ÍÎÌÅÐ_ÏÎÑÒÀÂÙÈÊÀ, Ð.ÍÎÌÅÐ_ÄÅÒÀËÈ

FROM                               S, P

WHERE                S.ÃÎÐÎÄ = Ð.ÃÎÐÎÄ;

Èìååì ðåçóëüòàò:

ÍÎÌÅÐ_ÏÎÑÒÀÂÙÈÊÀ

ÍÎÌÅÐ_ÄÅÒÀËÈ

S1



S1

S1

S2

S2

S3

S3

S4

S4

S4

P1

P4

P6

P2

P5

P2

P5

P1

P4

P6



Ñîäåðæàíèå ðàçäåëà