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 |
|
Dragonist
Starting Member
9 Posts |
 Posted - 2004-07-15 : 05:32:53
|
| Hi all, I am currently having a problem with the outer join method. I have a query in my database:MasterList2_Query.I create a query named Step1 which refer to MasterList2_Query.I create another query named Step2 which also refer to MasterList2_Query.Then I create the last query named Step3, which I try to join some columns from Step1 to Step2. Below is my Step3 sql statement:SELECT Step1.fldProductNameA, Step2.AreaB, Step2.fldProductNameB, Step2.MSDSNumB, Step2.idxManufacturerBFROM Step2 RIGHT JOIN Step1 ON Step1.AreaA = Step2.AreaB;And it gives a prompt to enter the "Step2.fldProductName" manually, there is no "Step2.fldProductName" in my Step2 query, there is only "fldProductNameB", "fldProductNameB" only exist on MasterList2_Query, where all the Step(s) queries refer to. I checked and re-checked, modifying and trying every possibilitiee as possible but I find my statement logically correct and doesn't know what's wrong with it. Any help would be much much appreciated. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-07-16 : 19:19:59
|
| please post ddl for all queries. Don't forget to use the code button in the online editor to format your code (it has the '#' symbol on it)-ec |
 |
|
|
|
|
|
Can Outer Join Method combine 2 Queries?