select * from table_name where conditions

table_name is a join of various tables A,B,C...

conditions are the conditions.

Now, I want to verify if the above table contains data with B.ENABLED='N' or not. How do I do it?

  • Please show us the SQL and sample data and sample result.
    – Rick James
    Apr 1 at 6:12
  • SELECT EXISTS (select * from table_name where conditions AND B.ENABLED='N')
    – Akina
    Apr 1 at 7:03
  • @RickJames I tried a lot but I don't think it can be boiled down to a table, because my entire query is to find out whether the "joined-table" consists of the data that I am interested in.
    – barnyard9
    Apr 1 at 7:47


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.