选择多个表的问题?mysql数据库
<%
sql1="select * from tz_send,hot_send,dsinfo_send,tupian_news,dy_send where tz_send.state='0' or hot_send.state='0' or dsinfo_send.state='0' or tupian_news.state='0' or dy_send.state='0' order by tz_send.id desc";
dbConn.execSQL(sql1);
if(!dbConn.next())
{%>
<div align="center"></div>
<img src="images/red.gif" width="88" height="30" border="1">
<%}
else
{
int i;
i=0;
while(i<1 &&!dbConn.isAfterLast())
{
%>
<div align="center"></div>
<img src="images/green.gif" width="88" height="30" border="1">
<%
dbConn.next();
i++;
}
}
%>
如果数据库中有两条state='0' 的数据的时候,此段就会出错!请高手们指导