I have two sql statements. The first has a unique primary key on name, whereas the second is a one to many relationship on name. I would like to join the two queries so the result looks like:
John Smith, 234 Jones Rd, 430-293-3928, note1
John Smith, 234 Jones Rd, 430-293-3928, note2
John Smith...