Export related records
I have two related databases, order and line item. I need to export a code from each line item into a single line with the order. For example, Order #1 has line item A and line item B. I need an export that gives me one column with order number and the second column with the line items codes A and B ( #1 | A B ). Any ideas on how to do this?