PostgreSQL

Скачать в pdf «PostgreSQL»


Internally, the database performs the join by carrying out the following operations:


•    salesorder.order_id = 14673: Find that row in the salesorder table.


•    salesorder.customer_id = customer.customer_id: From the row just found, get the customerjd. Find the equal customerjd in the customer table.


•    customer.name: Return name from the customer table.


Л


II


+->


</>


cu


+->


insert


into


customer


VALUES (


test(>


648,


test(>


‘Fleer Gearworks


test(>


‘1-610-555-7829’,


test(>


‘830 Winding Way


test(>


‘Millersville’,


test(>


‘AL’,


test(>


‘35041’,


test(>


‘USA’


test(>


);


insert


19815


1


Л


II


+->


(/)


cu


+->


insert


INTO employee


VALUES (


test(>


24,


test(>


‘Lee Meyers’,


test(>


’10/16/1989′


test(>


);


insert


19816


1


Л


II


+->


(/)


cu


+->


insert


INTO part VALUES (


test(>


153,


test(>


‘Garage Door Spring


test(>


6.20

Скачать в pdf «PostgreSQL»