up2718q:SQL语句的菜鸟问题

来源:百度文库 编辑:查人人中国名人网 时间:2024/04/29 23:21:40
sql="select * from [user] ,[down] where down.username='"&username&"' and down1=1 and user.username=down.user_xx and key=0 order by upkey"

把条件down1=1
改成
down1,down2,down3,down4,down5,down6,down7,down8,down9,down10等于1的都满足

...and down1+down2+down3+down4+down5+down6+down7+down8+down9+down10=10