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 in (select giftlist_id 6 from core.dcs_user_wishlist 7 where user_id = '**hidden_id**')) 8 and g.catalog_ref_id = i.catalog_ref_id 9 and s.sku_id = i.catalog_ref_id; CATALOG_REF_ID STOCK_LEVEL DISPLAY_NAME --------------- ----------- ---------------------------------------- 0502742 452 EXPRESS LIP GLOSS 9444005 44 SNAKESKIN PRINT HALTER SLIP DRESS 9508537 19 CLASSIC POINTED TOE RUNWAY PUMP 9293184 134 DRAWSTRING SIDE STRIPE TRACK PANT 8681883 598 CROPPED MESH INSET GRAPHIC TEE - AZTEC 2285635 41 NEP KNIT BASEBALL TEE 8686010 235 BELL SLEEVE LACE TRAPEZE TOP 7413048 245 BORDER PRINT RUFFLED MAXI DRESS 8311199 53 SCUBA AND CAT GRAPHIC MINI SKIRT 9508848 64 HIGH HEELED PUMP 2285628 10 NEP KNIT BASEBALL TEE 9129304 20 LOW RISE ANKLE ROLLED BOYFRIEND JEAN 12 rows selected. SQL>