Two Group contain similar record in one specific colummn
Respected All, Please share your expertise on this. i have a table MY First Table is having SKU without suffix BASE SKU PRODUCT 1 PRODUCT 2 PRODUCT 3 ABC123 Phone Pen Note ABC123 Phone Pen Note star XUZTUV MOUSE KEYBOARD WIRELESS XUZTUV MOUSE KEYBOARD WITH WIRE LMNOP123 MOUSE KEYBOARD WIRELESS LMNOP123 MOUSE KEYBOARD WITH WIRE My 2nd Table is having SKU with suffix GR and TN SKU with Suffix GR ABC123GR Phone Pen Note ABC123GR Phone Pen Note star SKU with Suffix TN ABC123TN Phone Pen Note ABC123TN Phone Pen Note star SKU with Suffix GR XUZTUVGR MOUSE KEYBOARD WIRELESS XUZTUVGR MOUSE KEYBOARD WITH WIRE SKU with Suffix TN XUZTUVTN MOUSE KEYBOARD WIRELESS XUZTUVTN MOUSE KEYBOARD WITH WIRE Odd Record with suffix GR Should not be in output as not available with all option **LMNOP123GR,MOUSE,KEYBOARD,WIRELESS** I Want to pull only those records when all item in product 3 for given Base SKU is also present with SKU With Suffix GR and TN Here Output should not contain LMNOP123GR as it not available with all option Present in Base SKU LMNOP123 Thanks a Lot. i just expand example for clarity. Thanks Again.