IPTOR SQL

Search with UPC with Extras

select PJPRDC, PJUNIT, PJEANP, PGDESC, LPLCID, SRSTHQ
	 from HD3800EFPN/SROEAN
		 inner join HD3800EFPN/SROPRG
			 on PJPRDC = PGPRDC
		 inner join HD3800EFPN/WHOLOP
			 on PJPRDC = LPPRDC
		 inner join HD3800EFPN/SROSRO
			 on PJPRDC = srprdc
	 where PJUNIT = 'EA' and SROEAN.PJEANP Like '%%'

Search for SKU with UPC

select PJPRDC, PJUNIT, PJEANP
	 from HD3800EFPN/SROEAN
	 where PJUNIT = 'EA' and PJPRDC = ''