I can try to help. Please provide more info
Are you getting any error
Sorry i am out of ideas
Hello,Sometimes pasting formatted data directly into this site doesn't render as you'd expect. It's quite difficult to read what the desired output is supposed to look like.
However, from your description and inspection of the data, I'm guessing maybe you're trying to combine sub-selects like this:
SELECT (SELECT somecolumns from sometables), (SELECT someothercolumns from someothertables)
That won't work. Since I can't really tell from the above just what your output is supposed to look like (e.g. I can't tell where the line(s) end) I'm not sure how to advise.
You may need an outer join, or multiple selects into some temp table(s), perhaps a stored procedure with a cursor.... so,
could you please upload any files (i.e. your sample output as a text file that looks correct in notepad)
to wikisend.com (or a file sharing site of your choice) so I may have a look?
It would also help if I had access to your table schema in some form
If there are multiple files, it's easiest to put them in a compressed (zipped) folder and upload just that one item.