We are currently viewing data from Oracle tables but changing records or doing a search is extremely slow. I need to set up a script to run nightly which will import all the records (less than 5,000) from three Oracle views to FileMaker tables. I can't figure out what the SQL Query is suppose to look like. I've tried using the SQL Query Builder but my SQL statement is either not allowed, or keyword not found, or table/view does not exist (though I picked it from the builder) .
An example would be most appreciated.