Hi - having some problems and need some help.
Background:
1. Table #1 "tblFocusItems", in which has focus items
2. Table #2 "tblComments", comments related to the above focus items
SQL Query to join the columns into one:
SELECT [FocusItems]+". "+nz([Deliverable],"") AS [Focus/Deliverable]
FROM tblDeliverable RIGHT JOIN tblFocusItems ON tblDeliverable.FocusID = tblFocusItems.FocusID;
Problem:
I want to join the two columns from both tables into a signal string; however, the FocusItem duplicates for each Comment.
What's happening:
Focus Item: Test SQL db
Comment #1: backup db
Comment #2: run test
Query:
Test SQL db. backup db
Test SQL db. run test
What should happen:
Test SQL db. backup db. run test
There doesn't need to be a specific order to the comments, any order will do.
Start Free Trial
