ATG – printing items in a giftlist

What is below will print all SKU’s in a giftlist for a given profile… SQL> select g.catalog_ref_id, stock_level, s.display_name 2 from core.dcs_giftitem g, core.dcs_inventory i, cata.dcs_sku s 3 where id in (select giftitem_id 4 from core.dcs_giftlist_item o 5 where giftlist_id…