joins

SQL Server and Oracle joins tutorials

Hello All, Question 1: I am learning SQL Server and Oracle joins (inner joins, outer joins...) and case statements syntax. Though I can google for the info, but would like to ask for some sites, links, and materials that fully explain the joins and case statments. Once again, thanks. Thanks gentlemen. Question 2: I am running a sim...

Is Join or Where clause approach more efficient in restricting result set?

I need to restrict a result set for a SELECT statement based upon Col1 have 1-to-many potential values. For example, I want to return all rows where Col1 equals a value of 1, 2, and 3. So far I have two different approaches to restricting the result set: Approach #1 Inner Join Table1 On (Table2.ColA=Table1.ColA) And (Col1=1 And Col1=2...