like this ?
'comparison list additions
WADbSearch1_whereClause=BuildFilterString("products.master_cat","" & cStr( Request.QueryString("gauges") ) & "","","=",0,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("products.catagory","" & cStr( Request.QueryString("auto") ) & "","AND","=",0,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("products.sub_cat","" & cStr( Request.QueryString("gauge_size") ) & "","AND","=",0,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("products.sub_cat_2","" & cStr( Request.QueryString("gauge_type") ) & "","AND","=",0,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
my table is products so i added this to the query and it seems to work. Anywhere else i need to change it? would be nice if next release 2.0.7 just included the table name in front of the query section of code.