SELECT distinct op.OperatorID, op.CompanyName FROM tbl_MFR_TPF_Detail d, tbl_OPR_ClientOperators op WHERE d.tpartnerType = 'OPR' AND d.productLevel = 'SKU' AND d.forecast_status != 'FPB' AND d.tpartnerID = op.OperatorID AND op.OwnerID = 1 AND op.FSLTableCode = 'MFR' ORDER BY op.CompanyName, op.OperatorID SELECT distinct s.skuid, s.sku, s.skuDesc, d.tpartnerID FROM tbl_MFR_TPF_Detail d, tbl_PRD_SKUs s, tbl_OPR_ClientOperators op WHERE d.tpartnerType = 'OPR' AND d.tpartnerID = #getCustomers.OperatorID# AND d.productLevel = 'SKU' AND d.forecast_status != 'FPB' AND d.productItemCode = s.sku AND s.OwnerID = 1 AND s.FSL_TableCode = 'MFR' ORDER BY s.sku SELECT op.OperatorID, op.CompanyName, op.MFRCustNum FROM tbl_OPR_ClientOperators op WHERE op.OperatorID = #getCustomers.OperatorID# SELECT forecast_qty, forecast_status FROM tbl_MFR_TPF_Detail WHERE MFR_ID = 1 AND tpartnerType = 'OPR' AND tpartnerID = AND productLevel = 'SKU' AND productItemCode = AND forecast_year = '2007' AND forecast_month = '#variables.month#' AND forecast_status IN ('FEB','A') SELECT forecast_qty, forecast_status FROM tbl_MFR_TPF_Detail WHERE MFR_ID = 1 AND tpartnerType = 'OPR' AND tpartnerID = AND productLevel = 'SKU' AND productItemCode = AND forecast_year = '2008' AND forecast_month = '#variables.month#' AND forecast_status IN ('FEB','A') #variables.RowData#