InfoPath Dev

I notice that when I create a connection to a database table, the Edit SQL box shows each field in quotes as well as each part of the table name, i.e., "dbo"."JobMaster". Since this is not the standard method of using quotes, I am puzzled as to what the syntax critera are for InfoPath. I am specifically interested in what modifications I must make to a SQL statement that I create in another tool (like SQL Server Query Analyzer). I am having problems getting sql statements created in QA to work in Infopath and am wondering what the problem may be. Can any one explain this to me?

Hi Dean,
Sorry but I have no idea.

What do you mean that double quotes are not proper syntax? IP uses Jet SQL to interact with the SQL server. Can you paste the query you're trying to get working?

What I mean is that when a SQL statement is written in other tools, such as Access or SQL Server, double quotes are not put around each part of the statement i.e., I'm used to seeing dbo.jobmaster without any quotes at all.