Datasource:carrera_quote_info
Template:sc_quote_info.htx

SQLStatement:SELECT Part_Number, Product_Type, Product_Name, Description
+FROM qry_OS
+WHERE (OS_Comp alike '%%%OS%%%');

SQLStatement:SELECT Part_Number, Product_Type, Product_Name, Description
+FROM qry_ProcessorSpeeds
+WHERE (Sys_Comp alike '%%%System%%%');

SQLStatement:SELECT Part_Number, Product_Type, Product_Name, Description
+FROM qry_Ram
+WHERE (Sys_Comp alike '%%%System%%%');

SQLStatement:SELECT Part_Number, Product_Type, Product_Name, Description
+FROM qry_Ethernet
+WHERE (Sys_Comp alike '%%%System%%%');

SQLStatement:SELECT Part_Number, Product_Type, Product_Name, Description
+FROM qry_VideoCard
+WHERE (Sys_Comp alike '%%%System%%%') and (OS_Comp alike '%%%OS%%%')
SQLStatement:SELECT Part_Number, Product_Type, Product_Name, Description
+FROM qry_CD
+WHERE (OS_Comp alike '%%%OS%%%');

SQLStatement:SELECT Part_Number, Product_Type, Product_Name, Description
+FROM qry_Storage
+WHERE (Sys_Comp alike '%%%System%%%');

SQLStatement:SELECT Part_Number, Product_Type, Product_Name, Description
+FROM qry_Removeable
+WHERE (Sys_Comp alike '%%%System%%%');

SQLStatement:SELECT Part_Number, Product_Type, Product_Name, Description
+FROM qry_Sound
+WHERE (Sys_Comp alike '%%%System%%%');

SQLStatement:SELECT Part_Number, Product_Type, Product_Name, Description
+FROM qry_Modem
+WHERE (Sys_Comp alike '%%%System%%%');

SQLStatement:SELECT Part_Number, Product_Type, Product_Name, Description
+FROM qry_Chassis
+WHERE (Sys_Comp alike '%%%System%%%');

SQLStatement:SELECT Part_Number, Product_Type, Product_Name, Description
+FROM qry_Monitor
+WHERE (Sys_Comp alike '%%%System%%%');

SQLStatement:SELECT Part_Number, Product_Type, Product_Name, Description
+FROM qry_Includes
+WHERE (Sys_Comp alike '%%%System%%%');