I am trying to write a select statement that will join 3 tables togeather, all of them have a common thing which i will use to pull from, ie a row identifier (number 4 for example). Table one is the main table and will only ever have one instance of this number, but table 2 and 3 may have many instances of this number as they store different comments from agents for 1 and admin for 2. I am writing a report using a data grid and would like to pull all of the infromation in from all the tables based on date range (which orderby date will work just fine)…I have tried the different joins, but do not get the desired result…I am using Eval(“row1”)…to fill in info at desired places…any suggestions?
