SQL Statement - FROM??????

[andrej27]

I'm a beginner with FileMaker - coming from an Access background (only intermediate in Access). I'm trying to execute an SQL statement from an external application and am having problems. Specifically, I'm not sure what to reference for the FROM statement. In Access, the FROM would reference the table.

Here's my SQL statement for FileMaker: Select Section FROM sesats WHERE Section = '3'

Section is the column in the FileMaker database. Currently I'm using "sesats" for FROM - that's the ODBC Data Source name.

What does FROM reference in SQL for FileMaker?

Thanks for any help you can give me.

[Kurt Knippel]

Filemaker is simply 1 table per file, so you would simply reference the ODBC data source name (i.e.SELECT * FROM fm_dbname WHERE section = 3 ).

I am by no means a SQL expert so I do not guarantee this, but this is what I have done in the past when working with Filemaker ODBC sources.