Select from one table matching criteria in another?

by

The simplest solution would be a correlated sub select:

select
    A.*
from
    table_A A
where
    A.id in (
        select B.id from table_B B where B.tag = 'chair'
)

Alternatively you could join the tables and filter the rows you want:

select
    A.*
from
    table_A A
inner join table_B B
    on A.id = B.id
where
    B.tag = 'chair'

You should profile both and see which is faster on your dataset.

More Related Contents:

  1. What is the result of following SQL Query?
  2. select yesterday date in where condition
  3. What is SQL injection? [duplicate]
  4. Natural Sort in MySQL
  5. Condition within JOIN or WHERE
  6. LISTAGG in Oracle to return distinct values
  7. Index for finding an element in a JSON array
  8. Database design for a survey [closed]
  9. Is there a LastIndexOf in SQL Server?
  10. Get all table names of a particular database by SQL query?
  11. How to set variable from a SQL query?
  12. Sub queries in check constraint
  13. Case in Select Statement
  14. How to use BOOLEAN type in SELECT statement
  15. Remove duplicates using only a MySQL query?
  16. Double colon `::` notation in SQL
  17. Split function in SQL Server 2008
  18. Remove numbers from string sql server
  19. T-SQL How to create tables dynamically in stored procedures?
  20. What is the equivalent of ‘describe table’ in SQL Server?
  21. How to read the last row with SQL Server
  22. PostgreSQL create table if not exists
  23. How can I add a column that doesn’t allow nulls in a Postgresql database?
  24. How can I group by date time column without taking time into consideration
  25. SQLite Order By Date1530019888000
  26. SQL Server: Find out default value of a column with a query
  27. Upsert with a transaction
  28. Update rows in one table with data from another table based on one column in each being equal
  29. How to include excluded rows in RETURNING from INSERT … ON CONFLICT
  30. Display next event date

Leave a Comment