select companyname from tbJob,tbCompany where tbJob.companyid=tbCompany.companyid
--用函数 --没有测试 CREATE FUNCTION GetStr(@CompanyID INT) RETURNS VARCHAR(1000) AS BEGIN DELCARE @RE VARCHAR(1000) SET @RE = '' SELECT @RE = @RE + jobtitle + '/' FROM tbJob WHERE companyid = @CompanyID RETURN LEFT(@RE, LEN(@RE) - 1) END GOSELECT companyname, dbo.GetStr(companyid) FORM tbCompanyDROP FUNCTION GetStr
from tbJob,tbCompany
where tbJob.companyid=tbCompany.companyid
--没有测试
CREATE FUNCTION GetStr(@CompanyID INT)
RETURNS VARCHAR(1000)
AS
BEGIN
DELCARE @RE VARCHAR(1000)
SET @RE = ''
SELECT @RE = @RE + jobtitle + '/' FROM tbJob WHERE companyid = @CompanyID
RETURN LEFT(@RE, LEN(@RE) - 1)
END
GOSELECT companyname, dbo.GetStr(companyid) FORM tbCompanyDROP FUNCTION GetStr