SQL query in calculated field

in what lenguage are your programming?
be more explicit in your question please, you give no affordable info to the post.

If I understand correctly, you want the formula of the computed field in MS SQL Server ?
however, you cross-posted in MySQL, so please clarify

note: this article should give the information, registration is required, though:
www.sqlservercentral.com/articles/Administering/queryingsystemtables/1906/ 

It's a FileMaker database. I've set up ODBC connections to other databases and use SQL queries in the FM script definitions to select, insert, update, etc. All of those SQL queries rely on an action to trigger to the script. What I'd like to do is set up a field in FM that can dynamically update itself with data from one of the other databases-- so as the data changes in the other database I would see the current data rather than having to trigger an update script. I was thinking of two options 1) defining a text field in FM that is defined to look up data, but that doesn't work because it only allows lookups to other FM databases; or 2) defining a calculation field that uses an SQL query, but I don't know if that's possible. I *think* I remember old versions of FM allowed for an "[execute (external) SQL ]..." function (or something like that. But I don't know the format and can't seem to find any information. If it's not possible to write a SQL command into a field calculation, is there another way to set up a FM field to pull live data from another database (with a pre-established ODBC connection)?
Thanks,
Dave