Has anybody else had any problems with the VB.Net query builder? I think it is a shocker.

I have two tables, join them together and it works sweet. I then "Add Table" in a 3rd, join them and so then it builds the SQL, right click the Results pane, Run and then it gives me an SQL error.

if i then take that SQL to Access, it gives me the same error. I use Access to fix it up, then copy and paste it back, then SQL Error.
Error message reads: "Syntax Error in SQL statement".

how do other people do these things?