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 col3 FROM S_STATUS JOIN S_GROUP_XREF ON S_STATUS.STR_ID = S_GROUP_XREF.STR_ID JOIN 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. |
 |
|
|
|
|