Ðàçðàáîòêà áàç äàííûõ â Delphi. 11 Óðîêîâ

       

 Ñïèñîê ïîëåé


SELECT first_name, last_name, phone_no

FROM phone_list      ïîëó÷èòü ñïèñîê
                                                         èìåí, ôàìèëèé è ñëóæåáíûõ òåëåôîíîâ
                                                         âñåõ ðàáîòíèêîâ ïðåäïðèÿòèÿ

FIRST_NAME    LAST_NAME            PHONE_NO            

============= ==================== ====================

Terri         Lee                  (408) 555-1234      

Oliver H.     Bender               (408) 555-1234      

Mary S.       MacDonald            (415) 555-1234      

Michael       Yanowski             (415) 555-1234      

Robert        Nelson               (408) 555-1234      

Kelly         Brown                (408) 555-1234      

Stewart       Hall                 (408) 555-1234      

...

Îòìåòèì, ÷òî PHONE_LIST - ýòî âèðòóàëüíàÿ òàáëèöà (ïðåäñòàâëåíèå), ñîçäàííàÿ â InterBase è îñíîâàííàÿ íà èíôîðìàöèè èç äâóõ òàáëèö - EMPLOYEE è DEPARTMENT.  Îíà íå ïîêàçàíà íà ðèñ.1, îäíàêî, êàê ìû óæå óêàçûâàëè â îáùåé ñòðóêòóðå êîìàíäû SELECT, ê íåé ìîæíî îáðàùàòüñÿ òàê æå, êàê è ê “íàñòîÿùåé” òàáëèöå.



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