How do you join several records from one table (tbl names) into one record in a new table (tbl ready)? This table (one record made-up of several records from another table) will be exported into another program and only be used to fill in a text field to set up a crawl on a marquee. The resulting record in (tbl ready) should look like "Bob, Ted, Joe"
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do you join several records from one table into one record?
- Thread starter AllanWLJC
- Start date
see FAQ701-4233
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question