I have this conditional join right here, thanks to the help of the community yesterday
INSERT INTO shipping(sdate, rec_wh, shipping, item)
SELECT ship_date, receiver_warehouse, ord, custitemcode
WHERE custitemcode = 'SOME ITEM'
AND (SELECT SUM(ord)
WHERE in_item = 'SOME ITEM') = (SELECT SUM("tSHIPPING")
WHERE "tITEM" = 'SOME ITEM');
While this achieves what I am trying to do when i use the variable 'SOME ITEM'
I need this to be accomplished on all items in that column that match the above statement. I have tried different variations of the above and it does not work
so lets say in columns, IN_ITEM and t_ITEM have 'SOME ITEM' and other items (eg, 'some item2' 'some item3' etc etc
i want this to happen to all rows where column data matches