Ok so..

Using the Sql query command then 'for each var in row' bit found in this tutorial

http://www.microsoft.com/web/post/web-development-101-part-5-using-data

I have a different SQL command now that uses 'Left Join' which works and create a string of HTML of what i want though when i call in in my page it just displays the HTML and breaks it a bit rather than showing what the code should do.

hope this makes sense! any ideas?