Code SQL statements to create a join that has all data about

*Code SQL statements to create a join that has all data about both tables*

BOAT (LicenseNumber, Type, Length)

SLIP (SlipNumber, Location, Charge, LicenseNumber )

Solution

Answer:

Below is the query that will fetch all the data about both taables based on LicenseNumber.

select b.LicenseNumber , b.Type, b.Length, s.SlipNumber, s.Location, s.Charge from BOAT b, SLIP s where b.LicenseNumber = s.LicenseNumber ;