. , , . / , .
Select Query QBE. , . , , QBE. QBE- S Access SQL-. SQL.
, , . , Property_for_Rent (. 3) (Pno), (city), (Type) (Rent) QBE , 3, .
, , Property_for_Rent (.. 3, ). SQL-onepaop :
SELECT PROPERTY_FOR_RENT.Pno, PROPERTY_FOR_RENT.City, PROPERTY_FOR_RENT_Type, PROPERTY_FOR_RENT.Rent FROM PROPERTY_FOR_RENT;
. 3.
, . Criteria, Access , AND () OR (). QBE, Access AND. , , . QBE, Microsoft Access OR. , .
, , 350 450 , Glasgow Criteria City Between 350 And 450 Criteria Rent. QBE 4, .
QBE
SELECT PROPERTY_FOR_RENT. Pno, PROPERTY_FOR_RENT.CIty, PROPERTY_FOR_RENT.Type,
PROPERTY_FOR_RENT.Rent
|
|
FROM PROPERTY_FOR_RENT
WHERE (((PROPERTY_FOR_RENT.City)=GlasgoW) AND ((PROPERTY_FOR_RENT.Rent) Between
350 And 450));
. 4.
, , (. 4, ). SQL- . 4, .
. , , .
, ; , QBE. , , , , , 5, . ( Owner Property_for_Rent) QBE.
Owner Fname Lname, Property_for_Rent n City. , , (. 5, ). SQL- 5, .
, 5, () .
, , , .. Microsoft Access , . , 5, Access . 1 . , . , , .
Access - , . , QBE. , . , . 5, Ono ( ) Owner erty_for_Rent. , .
. , ? ?
SELECT OWNER.FName, OWNER.LName,
PROPERTY_FOR_RENT.Pno,PROPERTY_FOR_RENT.City FROM OWNER INNER JOIN PROPERTY.FOR.RENT ON
|
|
OWNER.Ono = PROPERTY_FOR_RENT.Ono;
. 5.
( ). Microsoft Access , (Sum), (Avg), (Min) () , (Count). , Totals, QBE Total. , , .
, . , , , . City, Group By, Count. QBE 6,, 6,. 6, SQL- .
SELECT PROPERTY_FOR_RENT.CIty, Count (PROPERTY_FOR_RENT.Pno) AS CountOfPno FROM PROPERTY_FOR_RENT GROUP BY PROPERTY_FOR_RENT.City;
. 6.