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 |
|
dwdwonw
Starting Member
21 Posts |
 Posted - 2010-06-02 : 12:13:18
|
| This should work but doesn't. I can't seem to figure out where I'm going wrong. Any suggestions are appreciated!Thanks,DanSELECTC.BillingCycleID, C.CustID, C.LocalName, B.DescriptionFROM tblCustomer AS C INNER JOIN tblBillingCycles AS B ON B.BillingCycleID = C.BillingCycleID |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-06-02 : 12:28:35
|
| What isn't working about it? The only syntax error in your example is that is there no space between your SELECT and C.BillingCycleID.JimEveryday I learn something that somebody else already knew |
 |
|
|
dwdwonw
Starting Member
21 Posts |
Posted - 2010-06-02 : 15:38:51
|
| Even with the space, it crashes on me. Only when I remove the table names from the column names in the ON part of the clause do I get a result, which, of course, ends up being the cartesian product. |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-06-02 : 16:17:23
|
quote:
Even with the space, it crashes on me
What specific error did you receive? |
|
|
|
|
|
|
Help with inner join