Anonymous

select mfgstones.`no.` as `no.`, mfgstones.PolishedCaret as PolishedCaret, mfgstones.`FluoreScence` as FluoreScence, mfgstones.Color as Color, mfgstones.Clarity as Clarity, mfgstones.Shape as Shape, mfgstones.MfgNote as MfgNote, tenders.company as company from mfgstonesinner join stones on mfgstones.stonenumber=stones.`no.`inner join tenders on tenders.`no.`=stones.tendernumberUnknown column 'mfgstones.FluoreScence' in 'field list'CREATE TABLE `mfgstones` (  `No.` bigint(20) NOT NULL auto_increment,  `StoneNumber` bigint(20) NOT NULL,  `PolishedCaret` float default NULL,  `Color` varchar(20) default NULL,  `Clarity` varchar(5) default NULL,  `Shape` varchar(15) default NULL,  `  	FluoreScence` varchar(15) NOT NULL,  `MfgStatus` varchar(30) default NULL,  `Certified` varchar(5) default NULL,  `MfgNote` varchar(200) default NULL,  `Sold` varchar(5) default NULL,  PRIMARY KEY  (`No.`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;CREATE TABLE `stones` (  `No.` bigint(20) NOT NULL auto_increment,  `ParcelNumber` bigint(20) NOT NULL,  `RoughModel` varchar(10) NOT NULL,  `RoughCaret` float NOT NULL,  `PolishedCaret` float NOT NULL,  `Color` varchar(20) NOT NULL,  `Clarity` varchar(5) NOT NULL,  `Shape` varchar(15) NOT NULL,  `FluoreScence` varchar(15) NOT NULL,  `ValuePerCaret` float NOT NULL,  `BidPerCaret` float NOT NULL,  `Total` float NOT NULL,  `Note` varchar(250) NOT NULL,  `TenderNumber` bigint(20) NOT NULL,  `Status` int(11) NOT NULL,  PRIMARY KEY  (`No.`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stone Info' AUTO_INCREMENT=37 ;CREATE TABLE `tenders` (  `No.` bigint(20) NOT NULL auto_increment,  `Buyer` bigint(20) NOT NULL,  `Date` date default NULL,  `Company` bigint(20) NOT NULL,  `PerBack` bigint(20) NOT NULL,  PRIMARY KEY  (`No.`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='tenders table' AUTO_INCREMENT=8 ;