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, 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 SROEAN.PJUNIT = 'EA' and SROEAN.PJPRDC = ''

List Customers + Account Group

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