I'm trying to return the records of a table where three columns match up, but i'm getting no results in return. Any suggestions?
SELECT *
FROM Flights
WHERE Departure_IATA_Code = 'STN'
AND Arrival_IATA_Code = 'DBN'
AND Departure_Date = 2018-04-16
Create table statements
CREATE TABLE `Flights` (
`Flight_Number` varchar(50) NOT NULL DEFAULT '',
`Aircraft_ID` int(7) NOT NULL DEFAULT '0',
`Departure_IATA_Code` varchar(3) NOT NULL DEFAULT '',
`Departure_Date` date NOT NULL,
`Arrival_IATA_Code` varchar(3) NOT NULL DEFAULT '',
`Cost` int(7) NOT NULL,
`Departure_Time` time NOT NULL,
`Flight_Duration` time NOT NULL,
PRIMARY KEY (`Flight_Number`,`Aircraft_ID`,`Departure_IATA_Code`,`Departure_Date`,`Arrival_IATA_Code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
CREATE TABLE
statements for the tables in question adding the desired output. Use formatted text please, no screen shots