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.
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.