Peform multiple 'Where' statements in SQL query for Filemaker update

Posted on 2006-05-22
Last Modified: 2010-08-05
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?
Question by:macfundi
    1 Comment
    LVL 28

    Accepted 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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now