Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cthegraves
Starting Member
13 Posts |
 Posted - 2007-12-05 : 16:22:28
|
| Yes, I need to join the two tables with a similar column and then restrict with the where function, correct?Thanks!Scott |
|
|
gavakie
Posting Yak Master
221 Posts |
Posted - 2007-12-05 : 16:25:37
|
| yeah,Select *From Employee Inner Join Job on Employee.name = Job.employeenameWhere Job.Salary between 25000 and 50000 |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-12-06 : 13:02:07
|
Scott, please continue on the thread and not to start a new thread for your reply.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Reply