macfundi
asked on
Peform multiple 'Where' statements in SQL query for Filemaker update
I'm updating a filemaker database with an SQL query with the following query....
" SELECT * FROM \"orders\" WHERE \"orders\".\"Date_modified \" > " & Orders_MEMBERS::fDate_Modi fied_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?
" SELECT * FROM \"orders\" WHERE \"orders\".\"Date_modified
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.