Combining data into a single row

G

Guest

I have TableA in a one-to-many relationship with TableB. In TableB, each
record linked to its parent in TableA can be one of several types, as defined
by a value in the Type field.
I want to create a view of the records in Tables A and B where there is only
one row for each record in Table A and the Type data is shown as a series of
columns.

Is this possible?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

delete Using Join Statement 4
Is there a join that does this? 2
One-to-many query 4
hide repeat values in a join 2
How to read a table record by record and process and update another table 1
Need Help w/Nested Select 2
Subselect Query Problem 4
Delete record if a matching record is present in another table 3

Top