11-07-2011, 03:57 AM
(This post was last modified: 11-07-2011, 03:58 AM by Jacob__mybb_import1.)
b. SELECT * FROM tbl_holidays WHERE `Num Nights` = '14'
c. SELECT * FROM tbl_holidays WHERE Cost < '200'
d. SELECT * FROM tbl_holidays WHERE destination != 'France'
The second fixes in b and c might not be needed depending on which database you're using, but you definitely put in the wrong table name.
Having spaces in column names is horrible database design though...
c. SELECT * FROM tbl_holidays WHERE Cost < '200'
d. SELECT * FROM tbl_holidays WHERE destination != 'France'
The second fixes in b and c might not be needed depending on which database you're using, but you definitely put in the wrong table name.
Having spaces in column names is horrible database design though...