Database SQL Select and Join Query
CREATE TABLE IF NOT EXISTS `Customers` ( `CustomerID` int NOT NULL AUTO_INCREMENT, `CustomerLastName` varchar(50) NOT NULL, `CustomerFirstName` varchar(50) NOT NULL, `CustomerAddress` varchar(100) NOT NULL, `AptNum` varchar(20) NOT NULL, `City` varchar(50) NOT NULL, `State` varchar(3) NOT NULL, `ZipCode` varchar(9) NOT NULL, `HomePhone` varchar(15), `MobilePhone` varchar(15), `OtherPhone` varchar(15), PRIMARY KEY (`CustomerID`) ) DEFAULT CHARSET=utf8; INSERT INTO `Customers` (`CustomerLastName`, `CustomerFirstName`, `CustomerAddress`, `AptNum`, `City`, `State`, `ZipCode`, `HomePhone`, `MobilePhone`, `OtherPhone`) VALUES ('Martinez', 'Jose', '10201 W. Beaver ST', '147', 'Jacksonville', 'FL', '32220', '', '904-444-2137', '') ----------------------------------------------------- SELECT * FROM `Customers`