select cho_name from tbl_CHO_Operators with (nolock) where cho_id = select s.skuId, s.sku, s.skuDesc, m.MFR_NAME, b.brand, pkg.SCC14 as gtin from tbl_PRD_SKUs s with (nolock) left outer join tbl_PRD_Packaging pkg on s.skuId = pkg.linkId inner join tblManufacturers m with (nolock) on m.MFR_ID = s.mfrId left outer join tbl_MFR_Brands b with (nolock) on b.mfr_id = m.mfr_id and b.brand_Id = s.brandId and m.MFR_ID = where s.skuId = select email from tbl_FSPRO_Members with (nolock) where fspro_userId = select email from tbl_FSPRO_Members with (nolock) where fspro_userId = QUESTION - #qmd_getSkuInfo.sku# - #_skuDesc#...

This question was submitted on #dateFormat( Now(), 'MM/DD/YY' )# via the 1FS Schools website as follows:

Requestor Name:#variables.firstName# #variables.lastName#
Requestor Title:#variables.title#
Requestor's School:#variables.organization#
Requestor's School Co-op:#htmleditformat( qmd_schoolCoop.cho_name )#
Requestor's Phone:#variables.phone#
&##160;
Manufacturer Name:#qmd_getSkuInfo.mfr_name#
Manufacturer Brand:#qmd_getSkuInfo.brand#
Product ID:#qmd_getSkuInfo.sku#
Product GTIN:#qmd_getSkuInfo.gtin#
Product Description:#qmd_getSkuInfo.skuDesc#
&##160;
Questions / Comments Provided:#form.questions#



&##169; 2021, One Food Service. All Rights Reserved.