Untitled

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 mfgstones
inner join stones 
on mfgstones.stonenumber=stones.`no.`
inner join tenders on tenders.`no.`=stones.tendernumber

Unknown 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 ;