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 - 2006-03-20 : 09:11:07
|
| zakithi writes "the originally statement looked like this strSQL = strSQL & "LEFT JOIN Nationality ON Person.NationalityID = Nationality.NationalityID WHERE " now i need to join another table called status like this strSQL = strSQL & "LEFT JOIN Status ON Peron.StatusID = Status.StatusID " but it brings me an error message" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-20 : 09:12:54
|
| what is the error you get?Read about Joins in SQL Server help fileMadhivananFailing to plan is Planning to fail |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-20 : 10:53:51
|
| As a wild guess, i'd say that you haven't moved the WHERE to the end of the joins.. |
|
|
|
|
|
|
LEFT JOIN