Разработка приложений баз данных в Delphi. Шейкер Т.Д. - 98 стр.

UptoLike

ВУЗ: 

ДВФУ | Владивосток

Составители: 

Рубрика: 

98
SELECT eventNo, event_Name, CustNo, NumTickets
FROM events LEFT JOIN reservat
ON events.eventNo=reservat.eventNo
Рис. 39. Демонстрационная база данных «Заказ билетов»
Рис. 40. Заказ билетов (LEFT JOIN)
custoly
CustNo
Last_Name
First_Name
VIP_Status
Address1
Address2
City
State/Prov
Post_Code
Country
Phone
Fax
Email
Remarks
reservat
ResNo
EventNo
CustNo
NumTickets
Amt_Paid
Pay_Method
Card_No
Card_Exp
Pay_Notes
Purge_Date
Paid
events
EventNo
VenueNo
Event_Name
Event_Date
Event_Time
Event_Description
Ticket Price
venues
VenueNo
Venue
Capacity
Venue_Map 
SELECT eventNo, event_Name, CustNo, NumTickets
FROM events LEFT JOIN reservat
ON events.eventNo=reservat.eventNo

   custoly                     reservat                    events
   CustNo                      ResNo                       EventNo
   Last_Name                   EventNo                     VenueNo
   First_Name                  CustNo                      Event_Name
   VIP_Status                  NumTickets                  Event_Date
   Address1                    Amt_Paid                    Event_Time
   Address2                    Pay_Method                  Event_Description
   City                        Card_No                     Ticket Price
   State/Prov                  Card_Exp
   Post_Code                   Pay_Notes
   Country                     Purge_Date                  venues
   Phone                       Paid                        VenueNo
   Fax                                                     Venue
   Email                                                   Capacity
   Remarks                                                 Venue_Map


            Рис. 39. Демонстрационная база данных «Заказ билетов»




                     Рис. 40. Заказ билетов (LEFT JOIN)

                                     98

Страницы