|
-
Jul 25th, 2008, 10:40 AM
#2
Re: Problem in SQL Statement
That is perfectly normal behaviour - joins bring together all rows that match the conditions, even if it means values from the other table(s) are repeated.
Presumably it returns the rows as you want if you leave out the AdditionalComments table (and AnswerText2, which you don't need anyway).
If that is the case, you need to decide which row to get from AdditionalComments when there are multiple to choose from (eg: do you want "ok ok" or "yes"? ..and why did you choose that one rather than the other?)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|