Link to home
Start Free TrialLog in
Avatar of macfundi
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_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?
ASKER CERTIFIED SOLUTION
Avatar of Member_2_908359
Member_2_908359
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial