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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-29 : 23:59:45
|
David writes "When I started to learn SQL I always combined two tables in the where stmt.
For example: WHERE customer.id=status.id
This stmt worked fine but I was told not to use the WHERE stmt for this kind of operation. Instead I should join the tabels with a JOIN stmt. What's the difference? Do I increase performance by using the JOIN or have I been told wrong?" |
|
|
|
|
|
About the JOIN stmt