Query Assistance RRS feed

  • Question

  • Hi,

    I have table A that has columns OrderID (PK) & Name. I also have a second table B that has ImageID (PK), OrderID (FK), FileName

    For each row in Table A there is multiple rows in Table B  (i.e. each order has multiple images)

    When I go to query tables (joined on orderid) on an order that has say 4 images. I get 4 columns with all the data. I was hoping to get 1 columns with all the data then 3 columns with just TableB.FileName

    Would appreciate any assistance on what I need to research to achieve this.

    Thanks in advance.


    Thursday, August 18, 2016 11:44 PM


All replies