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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Format This Code!

Author  Topic  empire Starting Member 40 Posts Posted - 2001-05-31 : 11:39:26 Hello, Im trying to break away from the old SQL syntax and move to the new (well..) 92 SQL syntax. The main reason I have not switched is becuase I dont think it reads well, so below is old and new from/where clause, format it the way you write code and post it. --Old-- From tblBBPManager M, tblBBPBuyer B, tblBBPOpportunity O Where M.ManagerId = B.ManagerId And B.BuyerId = O.BuyerId --New-- From tblBBPManager M Inner Join ( blBBPBuyer B Inner Join tblBBPOpportunity O On B.BuyerId = O.BuyerId ) On M.ManagerId = B.ManagerId Thanks