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. |
 |
|
|
|
|
|
Parameter col1 has no default value.