merge cell contents

• • Reply

  18 years ago

  by takeoffm77

  Martin

  Dallas, TX, United States

  Joined 18 years ago

  Lets say I have
  

  
  Table 1:
  OrderID   InvoiceID
  -----------  --------------
  10             ABC
  11             DEF
  12             GHI
  

  
  and
  

  
  Table2:
  OrderID   OrderedItem
  -----------  -----------------
  10             A1
  10             B2
  10             C3
  11             A1
  11             C3
  12             B2
  

  
  How do I get SQL to give me this output:
  

  
  OrderID   InvoiceID     Ordered_Items
  -----------  --------------    ------------------
  10             ABC               A1, B2, C3
  11             DEF                A1, C3
  12             GHI                B2
  

  
  

  
  Could anyone help me PLEASE?!
  

  
  Thanks a lot!
  

  
  Martin

  Report abuse