I'll provide as much info as i can think of and just ask me anything if you need more info.
Ok so i have information in 3 tables, see below for the columns. The info i will be printing out will be from the 'Items' table. I need the 'Jetting' table to get the year and the 'application_mappings' table to link the jetting_id with the item_id.
So, i need a query (or multiple query's) to select a product from 2010 (Jetting table) then link the id's of that back to the Items table to display all the items from 2010. I'm working with an existing system so no tables can be changed in any way.
Anything else let me know, thanks for your input!
application_mappings
Code: Select all
Field Type Null Default Comments
map_id int(11) No
jetting_id int(11) Yes NULL
item_id varchar(255) Yes NULL
map_created datetime Yes NULL
map_updated datetime Yes NULL
Code: Select all
Field Type Null Default Comments
ItemID varchar(255) No
IMARecordID varchar(25) Yes NULL
IMAName varchar(255) Yes NULL
ProductFamily varchar(255) Yes NULL
Name varchar(255) Yes NULL
Price decimal(10,0) Yes NULL
SalePrice decimal(10,0) Yes NULL
Finish varchar(50) Yes NULL
Construction varchar(50) Yes NULL
ItemStatusCode varchar(50) Yes NULL
Color varchar(50) Yes NULL
Size varchar(50) Yes NULL
PoundsLighterThanStock decimal(10,0) Yes NULL
Weight decimal(10,0) Yes NULL
Description text Yes NULL
CartImage varchar(255) Yes NULL
ThumbnailImage varchar(255) Yes NULL
DetailsImage varchar(255) Yes NULL
ZoomImage varchar(255) Yes NULL
Reorder int(11) Yes NULL
AdjustRate varchar(255) Yes NULL
OriginalImage varchar(255) Yes NULL
Stock int(11) Yes NULL
WholePrice decimal(10,0) Yes NULL
SoftGoodFileName varchar(50) Yes NULL
Disabled bit(1) No
Installation_Notes bit(1) No
Dyno_Charts bit(1) No
Tech_Tips bit(1) No
Marketing_Description text Yes NULL
Images bit(1) No
IMALastModifiedDate datetime Yes NULL
IMAAttribVehicle varchar(50) Yes NULL
IMAAttribStroke varchar(50) Yes NULL
IMAAttribType varchar(50) Yes NULL
IMAAttribConfiguration varchar(50) Yes NULL
IMAAttribMufflerConstruction varchar(50) Yes NULL
IMAAttribMufflerColor varchar(50) Yes NULL
IMAAttribMidpipeConstruction varchar(50) Yes NULL
IMAAttribEndcapConstruction varchar(50) Yes NULL
IMAAttribSparkArrestor varchar(50) Yes NULL
IMAAttribQuietInsert varchar(50) Yes NULL
IMAAttribHeaderConstruction varchar(50) Yes NULL
IMAAttribHeaderType varchar(50) Yes NULL
IMAAttribFitment varchar(50) Yes NULL
IMAAttribVersion varchar(50) Yes NULL
IMAAttribSoundLevel varchar(50) Yes NULL
IMAAttribWeightComparedtoStock varchar(50) Yes NULL
IMAAttribApparelStyle varchar(50) Yes NULL
IMAAttribApparelType varchar(50) Yes NULL
IMAAttribApparelSize varchar(50) Yes NULL
IMAAttribApparelColor varchar(50) Yes NULL
IMAAttribCreateDate varchar(50) Yes NULL
Code: Select all
Field Type Null Default Comments
ID int(11) No
ManufacturerURL varchar(250) Yes NULL
OtherURL varchar(250) Yes NULL
TextBody varchar(4000) Yes NULL
TYPE varchar(255) Yes NULL
MAKE varchar(255) Yes NULL
MODEL varchar(255) Yes NULL
YEAR varchar(255) Yes NULL
MAIN_JET varchar(255) Yes NULL
PILOT_JET varchar(255) Yes NULL
NEEDLE varchar(255) Yes NULL
NEEDLE_POSITION varchar(255) Yes NULL
POWER_JET varchar(255) Yes NULL
AIR_SCREW varchar(255) Yes NULL
FUEL_SCREW varchar(255) Yes NULL
COMMENTS varchar(255) Yes NULL