create table customer (
CustomerID int primary key,
FtName varchar (48),
LtName varchar(48),
Email varchar (75),
Town varchar (75),
Parish varchar(75)
);
create table Vehicle(
LicensePlate varchar(48) primary key,
Make varchar (48),
CarYear int
);
create table Rental(
Date_of_Borrowing date,
CustomerID int,
Vehicle_LicenseN varchar (48),
Rental_Duration_Days int,
primary key (CustomerID,Vehicle_LicenseN),
foreign key (CustomerID) references Customer(CustomerID),
foreign key(Vehicle_LicenseN) references Vehicle(LicensePlate)
);
What I have tried:
select distinct customer.CustomerID,customer.FtName,customer.LtName, rental.Date_of_Borrowing, rental.Vehicle_LicenseN,rental.Rental_Duration_Days, vehicle.Make,vehicle.CarYear
from rental, customer,vehicle
where vehicle.Make = 'toyota' and vehicle.CarYear > 1998;