CREATE PROCEDURE Images_Pledge
AS
BEGIN
(
SELECT * from Borrow where
(
(select pownname from Pledge)=(select ownname from Images)
and
(select pimagename from Pledge)=(select imagename from Images)
)
) (
select images from Images where
(
(select pownname from Pledge)=(select ownname from Images)
and
(select pimagename from Pledge)=(select imagename from Images)
)
)
END
GO
//////////////////////////////////////////////////////////////////////////////////////////
初学存储过程,这样写还能再简单些么,但是运行的时候出来的是有多个返回值,于是乎不显示,求解怎么能让返回值在一起输出!!!
需要第一个表的所有元素和第二个表的图片一起输出!
AS
BEGIN
(
SELECT * from Borrow where
(
(select pownname from Pledge)=(select ownname from Images)
and
(select pimagename from Pledge)=(select imagename from Images)
)
) (
select images from Images where
(
(select pownname from Pledge)=(select ownname from Images)
and
(select pimagename from Pledge)=(select imagename from Images)
)
)
END
GO
//////////////////////////////////////////////////////////////////////////////////////////
初学存储过程,这样写还能再简单些么,但是运行的时候出来的是有多个返回值,于是乎不显示,求解怎么能让返回值在一起输出!!!
需要第一个表的所有元素和第二个表的图片一起输出!
CREATE PROCEDURE Images_Pledge
AS
BEGIN
(
SELECT * from Borrow where ((select pownname from Pledge)=(select ownname from Images) and (select pimagename from Pledge)=(select imagename from Images))
)(
select images from Images where((select pownname from Pledge)=(select ownname from Images) and (select pimagename from Pledge)=(select imagename from Images))
)
END
GO
出现酱子的提示~~~·
需要取出Borrow表中所有字段 + Images表的images字段
条件{
Borrow表中的bownname字段=Images表中的ownname字段
以及
Borrow表中的bimagename字段=Images表中的imagename字段
/*因为只有这两个字段相等才能 确认他们的images值相对应!*/
}ownname和imagename 都存在的时候才能判断所需字段(images)的唯一性
有点乱,我也不懂怎么解释.......SELECT * from Borrow where
(
(select pownname from Pledge)=(select ownname from Images)
and
(select pimagename from Pledge)=(select imagename from Images)
)
)(
select images from Images where
(
(select pownname from Pledge)=(select ownname from Images)
and
(select pimagename from Pledge)=(select imagename from Images)
)
select B.*,I.images from Borrow as B
left join Images as I on I.ownname=B.bownname
and I.imagename=B.bimagename
这个试一下吧...