Ok I have 2 tables, A & B. Table A is a list of pipe segments, Table B is a list of repair dates. A common id is shared between the 2 tables, telling you which segment each repair happened on.



I want to make a query that pulls repair dates from B and adds it to A using new fields Repair1, Repair2....Repair10.

Probably easy to do but I am a total newb, please help!