1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

Query a table using data in another table?

Discussion in 'SQL - Questions and Answers' started by ben, May 29, 2006.

  1. ben Administrator

    Dialect: SQL 92
    I will be writing bit more about this shortly. For now this is just a place holder :)
    ben, May 29, 2006
    #1

  2. irfanhab New Member

    Dialect: SQL 92
    This can be achieved with Nested Queries

    SQL:

    
SELECT * FROM table1 where Salary=(Select salary from Salaries where SalaryType="Manager")
    irfanhab, May 29, 2006
    #2

Share This Page