select distinct sName as Name from s,p
where s.sid=p.pid
union
select distinct tName as Name from t,p
where t.tid=p.pid
where s.sid=p.pid
union
select distinct tName as Name from t,p
where t.tid=p.pid
解决方案 »
- id自动增长问题
- [100分]求黄色网址数据库.
- 咨询一个法律问题:帮助他人欺瞒上级所应付的相应责任是什么?
- 远程连接sql server,提示"sql 不存在或访问被拒绝",请大伙出点主意.
- +++++++ 如何在一个表中删除重复的项?+++++++
- 急求一个sql语句
- SQL语句,两个表,表A字段名类似C_1,C_2,C_3,C_4,表B(id,name)里有四条记录分别描述A表的四个字段,详细请进
- 帮我写句sql
- 求一sql语句
- 将access数据库远程传送到sql7.0.每天在access端将数据insert into sql7.0
- 关于sql server中临时表的概念理解,扬帆破浪,openvms
- 我传一个参数到存储过程,过程中如workid in(@windows),无法成功执行
union all
select s.Sname as name from p left join t on p.pid=t.tid where s.tid is not null
union
select p.pid,t.tname as name from p join t on p.pid=t.tid
(select tname name from p,t where pid=tid)
union all
select tname as name from t,p where t.tid=p.pid
(
select a.Pid,b.Tname from Ptable a,Ttable b where a.Pid=b.Tid
union
select a.Pid,b.Sname from Ptable a,Stable b where a.Pid=b.Sid) a order by a.Pid
(
select a.Pid,b.Tname from Ptable a,Ttable b where a.Pid=b.Tid
union
select a.Pid,b.Sname from Ptable a,Stable b where a.Pid=b.Sid) a order by a.Pid
union
select p.pid,t.tname as name from p join t on p.pid=t.tid
FROM P LEFT JOIN S ON P.PID=S.SID
LEFT JOIN T ON P.PID=TID
我的问题:
1、发出了读卡的命令inbuf = Chr$(&H1B) & Chr$(&H5D);MSComm1.Output = inbuf & vbCr,机器也有反应,但是刷卡后返回的数据应该如何接受并显示在text里哪(说明书上说:成功:<1B 73 磁道数据 3F 1C>失败:<1B 72 71>这些是16进制命令)?QQ121683833告诉我你是csdn的朋友哦~
去这里回答~:给分
http://www.csdn.net/expert/topic/795/795529.xml?temp=.664303
http://www.csdn.net/expert/topic/795/795518.xml?temp=.7766077
(select sName as Name, sid as Id from s
union
select tName, tid from t) as b
on P.Pid = b.Id
FROM P LEFT OUTER JOIN S ON P.PID=S.SID
LEFT OUTER JOIN T ON P.PIC=T.TID
select distinct Name = sName from s,p
where s.sid = p.pid
union
select distinct Name = tName from t,p
where t.tid = p.pid
通过以上方法实现的前提是:t.tid = s.sid = p.pid 不成立
from
(select s.sid as id, sName as name from s,p
where s.sid = p.pid
union
select t.tid as id, tName as name from t,p
where t.tid = p.pid)
then (select Sname from s where SID=p.PID) else
case when exists(select Tname from t where TID=p.PID)
then (select Tname from t where TID=p.PID) end end) from p