Perfect...thanks very much...my eyes were starting to cross

Thank you Resender however I've not been able to figure out where this goes. Is this code meant to fit inside this querry:

<asp:SqlDataSource ID="testeventtime" runat="server" ConnectionString="<%$ ConnectionStrings:testingdategoliathConnectionString %>" SelectCommand="SELECT...

Thank you for the suggestion. Unfortunately at this time, I haven't explored "Stored Procedures" so as a Rookie, I don't yet have the skill.

No not homework. A real honest project. I created a test table. I may not have the vocabulary to continue this string with you becasue I am a...

I haven't actually constructed the table but it will have three columns, with no links to any other tables. ID column with primary key int automatically adds an incremental....

Absoulutely 100% perfect...no errors and everything where it should be.

Thanks very much.

SELECT cbasagentroster.Lname, cbasagentroster.CellPh, cbasagentroster.AgentEM, cbasagentroster.offcodeID, officeinfo.offcodeID AS Expr1, officeinfo.office,

...

Thank you. I've tried everything including 'left" join but I get a syntax error for any value except "cross"

i've actually made some progress.

I created the querry:

SELECT cbasagentroster.Lname, cbasagentroster.CellPh, cbasagentroster.AgentEM, cbasagentroster.offcodeID, officeinfo.offcodeID AS Expr1, officeinfo.office,

...

Thanks very much to all who responded. This solved my problem. 🙂