Guest:
Register
|
Login
|
Member List
|
Search
|
Statistics
|
FAQ
Language
----------
Simplifed Chinese
Traditional Chinese
English
CnPack Forum
»
技术板块灌水区
» on 子句字段类型不同怎么办
‹‹ Last Thread
|
Next Thread ››
Poll
Trade
Reward
Activity
Printable Version
|
Email to Friend
|
Subscription
|
Favorites
Subject: on 子句字段类型不同怎么办
与龙共舞
新警察
UID 53659
Digest Posts 0
Credits 10
Posts 3
点点分 10
Reading Access 10
Registered 2010-10-20
Status Offline
#1
Post at 2010-10-23 10:29
Profile
|
Blog
|
P.M.
on 子句字段类型不同怎么办
如:
SELECT 成绩表.*,班级表.*
FROM "成绩表"cj INNER JOIN "班级表" bjb
ON (班级库.班级名1= 成绩表.班级名2)
如果“班级名1”为字符型,而“班级名2”这数型的
期盼高手回复!
[
本帖最后由 与龙共舞 于 2010-10-23 10:30 编辑
]
Passion
(LiuXiao)
管理员
UID 359
Digest Posts
19
Credits 6804
Posts 3577
点点分 6804
Reading Access 102
Registered 2004-3-28
Status Offline
#2
Post at 2010-10-23 20:24
Profile
|
Blog
|
P.M.
用CAST呢?
与龙共舞
新警察
UID 53659
Digest Posts 0
Credits 10
Posts 3
点点分 10
Reading Access 10
Registered 2010-10-20
Status Offline
#3
Post at 2010-10-23 22:26
Profile
|
Blog
|
P.M.
回复 #2 Passion 的帖子
CAST试了,好像不行,可能用法不对。能给个实例吗?先谢了!
Passion
(LiuXiao)
管理员
UID 359
Digest Posts
19
Credits 6804
Posts 3577
点点分 6804
Reading Access 102
Registered 2004-3-28
Status Offline
#4
Post at 2010-10-24 08:12
Profile
|
Blog
|
P.M.
搜一下CAST或CONVERT函数的用法吧。我要举例也是搜来的,没装SQL Server。
与龙共舞
新警察
UID 53659
Digest Posts 0
Credits 10
Posts 3
点点分 10
Reading Access 10
Registered 2010-10-20
Status Offline
#5
Post at 2010-10-24 10:17
Profile
|
Blog
|
P.M.
回复 #4 Passion 的帖子
已解决,我是在delphi中用的。谢谢了!
Poll
Trade
Reward
Activity
CnPack Forum
CnPack English Forum
> CnWizards IDE Wizards
> CVSTracNT
> Announcements & Others
All times are GMT++8, the time now is 2024-9-8 07:57
Powered by
Discuz!
5.0.0
© 2001-2006
Comsenz Inc.
Processed in 0.015840 second(s), 8 queries , Gzip enabled
TOP
Clear Cookies
-
Contact Us
-
CnPack Website
-
Archiver
-
WAP
Member's CP Home
Edit Profile
Credits Transaction
Public User Groups
Buddy List
Main
Page Views
User Agents
Posts History
Top Forums
Top Threads
Post Ranking
Credit Ranking
Online Time
Team
Moderation Stats