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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

One-to-many Data Combined on a Single Row

Status
Not open for further replies.

ihda

MIS
Apr 6, 2001
46
US
I have a one-to-many relationship between tableA and tableB. I need to write a sql statement to select data from the parent tableA and, on a single field, combine data from the child tableB.

Example: TableA has property information
TableB has contact information for the property

My output would look like this - one row:
property name, contact1 contact2 contact3, city

Thank you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top