I'm updating a filemaker database with an SQL query with the following query....
" SELECT * FROM \"orders\" WHERE \"orders\".\"Date_modified\" > " & Orders_MEMBERS::fDate_Modified_QUERY
In addition to the "Date_Modified" condition, I also need to only import orders whose "Completed" value ="1". This is a field in the orders table (titled 'completed') that has a value of "1" if the record is actually updated-- which are the only records that I'd like to import.
How do I insert this as part of the same query so that I can have both conditions met in the query?