【求助】关于JSP的一个数据问题

chinabill 02-12-03

saicheng表中有汕蚨樱TEAM1和TEAM2,F要求①程中的少队用色分_,但@色在SAIDUI表中,SQL SERVER程式中绾⑵淙〕觯

我的SQL Z句中是@拥
SELECT saicheng.team1, saicheng.team2, saidui.scolor
FROM saicheng CROSS JOIN
saidui
WHERE (saicheng.team1 LIKE saidui.lname) OR
(saicheng.team2 LIKE saidui.lname) AND (saicheng.id <> saicheng.id)

但@r取出的只有一支色,在JSP中要用到COLOR,怎麽做。望高手指教