Difference between revisions of "IPTOR SQL"

From PSC IT Wiki
Jump to navigation Jump to search
(Created page with "===Search with UPC with Extras=== <pre> select PJPRDC, PJUNIT, PJEANP, PGDESC, LPLCID, SRSTHQ from HD3800EFPN/SROEAN inner join HD3800EFPN/SROPRG on PJPRDC = PGPRDC...")
 
Line 13: Line 13:
===Search for SKU with UPC===
===Search for SKU with UPC===
<pre>
<pre>
select pjprdc,pjunit,pjeanp from hd3800efpn.sroean
select PJPRDC, PJUNIT, PJEANP
where pjunit='EA'
from HD3800EFPN/SROEAN
and pjprdc='16176'
where PJUNIT = 'EA' and PJPRDC = ''
</pre>
</pre>

Revision as of 18:36, 12 July 2017

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 = ''
Retrieved from "https://psc.zeropoke.net/index.php?title=IPTOR_SQL&oldid=733"