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 = ''

List Customers + Account Group

select NONUM, NANAME, NOAGRP
	 from HD3800EFPN/SRONOI
		 inner join HD3800EFPN/SR15NAM
			 on NONUM = NANUM
	 where (SRONOI.NOAGRP Like '%C%')