concatenate values from two tables into single table?

[impulse24]

Hi,

I can't figure this one out.

I have two tables:
BatchPage
BatchField

BatchPage structure:
DocID
PageID

BatchField Structure:
DocID
IndexFieldValue

Example Data in BatchField:
DocID IndexFieldValue
1 Barcode
1
1 Permission
1

Example Data in BatchPage:
DocID PageID
1 1
1 2
1 3

I want to perform a query that will output the results as follows:

DocID IndexValues PageIDInDoc
1 Barcode,,Permission, 1,2,3

I am basically combining multiple records from the two tables into a single record in a new table. I have used a cross query but it is outputting multiple records with the matching docid's. Please help.

 

[Warlocks]

Try using cursors.

Rather than me explain in detail, let me know if you don't know how to do it and then I shall demo.

john.wood@vantage-vts.co.uk

Woody.