Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

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?
1 Solution
simply by adding AND in between the 2 where conditions.
select ....
where [condition1] and orders.completed = 1
" SELECT * FROM \"orders\" WHERE \"orders\".\"Date_modified\" > " & Orders_MEMBERS::fDate_Modified_QUERY & " and  \"orders\".\"Completed\" = 1"

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now