Thread: Query a table using data in another table?
View Single Post
  #2 (permalink)  
Old 05-29-2006, 03:14 PM
irfanhab irfanhab is offline
Junior Member
  
Join Date: May 2006
Posts: 10
irfanhab is on a distinguished road
Default SQL 92 answer. Re: Query a table using data in another table?
This can be achieved with Nested Queries

[sql]
SELECT * FROM table1 where Salary=(Select salary from Salaries where SalaryType="Manager")
[/sql]
Reply With Quote