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

02-12-03 chinabill

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,怎麽做。望高手指教