Skip navigation links

MySQL Forums :: Newbie :: Scalar functions?


Advanced Search

Scalar functions?
Posted by: Aloys Ochola ()
Date: November 20, 2008 03:44AM

who can bail me out with a code hat produces a result to the following question?

Return a list of all flights along with their current un-discounted price

according to these tables;

CREATE TABLE `fly-four-less`.`flight_profiles` (
`FLP_ID` decimal(8,0) NOT NULL default '0',
`FLT_NUMB` decimal(4,0) default NULL,
`SEATS` int(11) default NULL,
`PRICE_CODE` varchar(50) default NULL,
`from` varchar(50) default NULL,
`to` varchar(50) default NULL,
`MON` varchar(1) default NULL,
`TUE` varchar(1) default NULL,
`NEXT_DAY` int(11) default NULL,
`WED` varchar(1) default NULL,
`THU` varchar(1) default NULL,
`FRI` varchar(1) default NULL,
`SAT` varchar(1) default NULL,
`SUN` varchar(1) default NULL,
`depart` datetime default NULL,
`arrive` datetime default NULL,
PRIMARY KEY (`FLP_ID`),
UNIQUE KEY `FLT_NUMB` (`FLT_NUMB`),
KEY `FK_flight_profiles_1` (`from`),
KEY `FK_flight_profiles_2` (`to`),
CONSTRAINT `flight_profiles_ibfk_1` FOREIGN KEY (`from`) REFERENCES `airports` (`IATA_CODE`),
CONSTRAINT `flight_profiles_ibfk_2` FOREIGN KEY (`to`) REFERENCES `airports` (`IATA_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `fly-four-less`.`price` (
`PC_ID` int(11) NOT NULL default '0',
`PC_LEVEL` int(11) default NULL,
`PRICE` int(11) default NULL,
`FROM_DATE` datetime default NULL,
`TO_DATE` datetime default NULL,
PRIMARY KEY (`PC_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `fly-four-less`.`discount` (
`DIS_ID` int(11) NOT NULL default '0',
`DAYS_ADV_MIN` int(11) default NULL,
`DAYS_ADV_MAX` int(11) default NULL,
`PASSENGER_TYPE` int(11) default NULL,
`DISCOUNT` int(11) default NULL,
PRIMARY KEY (`DIS_ID`),
KEY `FK_discount_1` (`PASSENGER_TYPE`),
CONSTRAINT `discount_ibfk_1` FOREIGN KEY (`PASSENGER_TYPE`) REFERENCES `person_type` (`PT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

i came up with the following lines of query, but its not the results, if help avails can i have a deeper explanation on how the query digs to the table(s)?
if someone is to ask me whether or not its an assignment again, please then explain or give me light forward ----

SELECT * FROM FLIGHT_PROFILES F
WHERE F.NEXT_DAY=0;

Aloys

Options: ReplyQuote


Subject Written By Posted
Scalar functions? Aloys Ochola 11/20/2008 03:44AM
Re: Scalar functions? Ron Mey-Ami 11/20/2008 08:58PM
Re: Scalar functions? Aloys Ochola 11/24/2008 05:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.