SQL Recipes (Beta II)
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers
Query a table using data in another table? Query a table using data in another table?

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
  #1 (permalink)  
Old 05-29-2006, 01:40 PM
ben ben is offline
Administrator
  
Join Date: Mar 2007
Posts: 77
ben has disabled reputation
Default SQL 92 dialect question:

Query a table using data in another table?

I will be writing bit more about this shortly. For now this is just a place holder :-)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

ANSWER(S):

  #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

SELECT * FROM table1 WHERE Salary=(SELECT salary FROM Salaries WHERE SalaryType="Manager")
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« How do i perform an If statement on a cloumn? | How to declare Composite Keys? »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
maximun number of columns define in sql server data table? sunder SQL - Questions and Answers 1 09-21-2007 02:39 PM
can i wrire a query which sum up more than 2 columns in a single table? kajal SQL - Questions and Answers 2 03-06-2007 12:41 AM


All times are GMT. The time now is 04:55 AM.

Contact Us - SQL Recipes - Archive - Top

Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2007 SQL Recipes

1 2 3 4 5 6 7