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 |
|
sethupandian
Starting Member
1 Post |
 Posted - 2007-06-06 : 07:38:17
|
| In a particular select statement am using "IN" operator and in the subquery am selecting the Max of date along with a group by function(which will return a set of max dates).Now the requirement is to use join instead of "IN" operator.all the tables used in the subquery are there in the main query also.Just help me to get the solution |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-06-06 : 07:44:30
|
| Since they do almost the same thing, how is it that the "requirement" changed. Do you still need the same information? If so, then the "requirement" hasn't changed. Or did the professor change the assignment?Either way, can you show us what you have so far? Table defs, sample data, sample output?[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
|
|
|
Join instead of IN operator