AnsweredAssumed Answered

Why is the following SQL query not producing proper results?

Question asked by lmurphy lmurphy on Mar 24, 2014
Latest reply on Mar 24, 2014 by Jason Eggers
I am trying to find some examples of simple sql queries.
An example would be an extract of all accounts that are note deleted and where the account type is Customer.

Here is what I have but the results are not accurate so I guess I am missing something:

SELECT

    *

FROM

    accounts

WHERE

    (accounts.account_type = 'Customer')

And

    (accounts.deleted = '0')





Outcomes