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 |
|
zhshqzyc
Posting Yak Master
240 Posts |
 Posted - 2010-03-26 : 09:45:57
|
| [code]SELECT col1=LANG1_CD, col2=LANG2_CD,col3=LANG3_CD FROM S_STATUS, S_GROUP_XREF, S_GROUP WHERE (S_STATUS.STR_ID= S_GROUP_XREF.STR_ID) And (S_GROUP_XREF.STR_GRP_ID = S_GROUP.STR_GRP_ID)[/code]It works fine in SQL Server 2005 but failed in Access.I want the script work in both.Thanks for advice. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-26 : 10:03:46
|
SELECT LANG1_CD as col1, LANG2_CD as col2,LANG3_CD as col3FROM S_STATUSJOIN S_GROUP_XREF ON S_STATUS.STR_ID = S_GROUP_XREF.STR_IDJOIN S_GROUP ON S_GROUP_XREF.STR_GRP_ID = S_GROUP.STR_GRP_ID
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Parameter col1 has no default value.