DIR : /home/kozerus/public_html/ko_center/sql/join_plan0-hw1.sql

/home/kozerus/public_html/ko_center/sql

select plan0.item, plan0.cab, plan0.amps, hw1.amps,
orownam,
upos1,
upos2,
network,
cpumem,
hrctag,
sn,
frankid,
purchased,
enddate,
rpdubank,
rpduoutlet,
switch,
port,
conn,
pmm,
panel,
breaker,
feed

from  plan0 , hw1
where 
	plan0.item = hw1.item and

	plan0.cab = hw1.cab

order by 
	plan0.item, plan0.cab, hw1.amps
	;