Help.Chris
Registered User.
- Local time
- Today, 09:25
- Joined
- Oct 11, 2000
- Messages
- 43
Hi everyone,
I have a database, with a one to many join, the one side is correct, but the many side i could do with merging into one record in a query.
ie.
1 side: campaign, code, id
many side: destination code
currently the many side contains data in the format MAN
LPL
GTW
I could do the the query outputting MAN, LPL, GTW as one record.
This would result in me getting one record for each item in the database, rather than several due to the many join.
Does anyone know if this is possible, i would be a great help if it is.
Chris
I have a database, with a one to many join, the one side is correct, but the many side i could do with merging into one record in a query.
ie.
1 side: campaign, code, id
many side: destination code
currently the many side contains data in the format MAN
LPL
GTW
I could do the the query outputting MAN, LPL, GTW as one record.
This would result in me getting one record for each item in the database, rather than several due to the many join.
Does anyone know if this is possible, i would be a great help if it is.
Chris