getcpidbycardid
in cdid int,out cpid int
BEGIN
#Routine body goes here...
SELECT
bcardtype.companyid into cpid
FROM
bcardbaseinfo
INNER JOIN bcardtype ON bcardtype.id = bcardbaseinfo.typeid
WHERE
bcardbaseinfo.id = cdid;
END
getcpidbycardid
in cdid int,out cpid int
BEGIN
#Routine body goes here...
SELECT
bcardtype.companyid into cpid
FROM
bcardbaseinfo
INNER JOIN bcardtype ON bcardtype.id = bcardbaseinfo.typeid
WHERE
bcardbaseinfo.id = cdid;
END