That still does not work. I guess I'm applying your suggestion wrong....
What you listed is inside () of the first JOIN ?
below was another method I was trying... and still no luck
SELECT its.itemid, its.storeid,
its.descr, its.onhandqty,
pt.price, pt.Effectivedttm...