select distinct a.* from tbl_ticket_log a,tbl_ticket b where a.ticket_id=b.ticket_id and b.hidden=0
select * from tbl_ticket_log where ticket_id in ( select ticket_id from tbl_ticket where hidden=0 ) SELECT A.* FROM `tbl_ticket_log` A LEFT JOIN `tbl_ticket` B ON A.ticket_id = B.ticket_id WHERE A.ticket_id IS NOT NULL AND B.hidden = 0
SELECT A.* FROM `tbl_ticket_log` A LEFT JOIN `tbl_ticket` B ON A.ticket_id = B.ticket_id WHERE A.ticket_id IS NOT NULL AND B.hidden = 0
SELECT A.* FROM `tbl_ticket_log` A LEFT JOIN `tbl_ticket` B ON A.ticket_id = B.ticket_id WHERE A.ticket_id IS NOT NULL 好像可以,但是如果在后面加上 AND B.hidden = 0 就不行!!!!
to: kirinwang(玄音埙) 真的吗?你试过吗?
那种方法绝对不能用!!!!!我现在用欠套查询可以解决这个问题: 给你一段代码,看看<% String depart_id="",depart_id2="",sql1="",sql2=""; sql="select * from 表1 where 表1限定条件"; rs.executeUpdate(sql); while(rs.next()) { depart_id=rs.getString("depart_id"); int i=0; String sql2="select * from foreiger_creat_flow where 限定条件1 and 限定条件2"; rs1.executeUpdate(sql2); while(rs1.next()) { depart_id2=rs1.getString("depart_id");
in
(
select ticket_id from tbl_ticket where hidden=0
)
SELECT A.* FROM `tbl_ticket_log` A
LEFT JOIN `tbl_ticket` B ON A.ticket_id = B.ticket_id
WHERE A.ticket_id IS NOT NULL AND B.hidden = 0
LEFT JOIN `tbl_ticket` B ON A.ticket_id = B.ticket_id
WHERE A.ticket_id IS NOT NULL
AND B.hidden = 0
LEFT JOIN `tbl_ticket` B ON A.ticket_id = B.ticket_id
WHERE A.ticket_id IS NOT NULL
好像可以,但是如果在后面加上 AND B.hidden = 0
就不行!!!!
真的吗?你试过吗?
给你一段代码,看看<%
String depart_id="",depart_id2="",sql1="",sql2="";
sql="select * from 表1 where 表1限定条件";
rs.executeUpdate(sql);
while(rs.next())
{
depart_id=rs.getString("depart_id");
int i=0; String sql2="select * from foreiger_creat_flow where 限定条件1 and 限定条件2";
rs1.executeUpdate(sql2);
while(rs1.next())
{
depart_id2=rs1.getString("depart_id");
if(depart_id2.equals(depart_id))
{
i=1;
rs1.last();
break;
}
}
if(i==0)
{
%>
执行相应操作
<%
}
}%>
# Table structure for table 'tbl_ticket'
#CREATE TABLE tbl_ticket (
ticket_id int(11) default NULL,
hidden tinyint(4) default NULL
) TYPE=MyISAM;#
# Dumping data for table 'tbl_ticket'
#INSERT INTO tbl_ticket VALUES("1", "0");
INSERT INTO tbl_ticket VALUES("2", "1");
INSERT INTO tbl_ticket VALUES("3", "1");
INSERT INTO tbl_ticket VALUES("4", "0");
INSERT INTO tbl_ticket VALUES("5", "1");
#
# Table structure for table 'tbl_ticket_log'
#CREATE TABLE tbl_ticket_log (
ticket_id int(11) default NULL,
note char(10) default NULL
) TYPE=MyISAM;#
# Dumping data for table 'tbl_ticket_log'
#INSERT INTO tbl_ticket_log VALUES("1", "A");
INSERT INTO tbl_ticket_log VALUES("1", "B");
INSERT INTO tbl_ticket_log VALUES("2", "C");
INSERT INTO tbl_ticket_log VALUES("3", "D");
INSERT INTO tbl_ticket_log VALUES("4", "F");
INSERT INTO tbl_ticket_log VALUES("5", "0");
INSERT INTO tbl_ticket_log VALUES("3", "G");
INSERT INTO tbl_ticket_log VALUES("2", "E");
#
# 测试语句1
#SELECT A.* FROM `tbl_ticket_log` A
LEFT JOIN `tbl_ticket` B ON A.ticket_id = B.ticket_id
WHERE A.ticket_id IS NOT NULL
AND B.hidden = 0
#
# 测试语句2
# SELECT B.* FROM `tbl_ticket` A
LEFT JOIN `tbl_ticket_log` B ON A.ticket_id = B.ticket_id
WHERE A.hidden = 0
/*
测试结果mysql> SELECT * FROM `tbl_ticket`;
+-----------+--------+
| ticket_id | hidden |
+-----------+--------+
| 1 | 0 |
| 2 | 1 |
| 3 | 1 |
| 4 | 0 |
| 5 | 1 |
+-----------+--------+
5 rows in set (0.00 sec)mysql> SELECT * FROM `tbl_ticket_log`;
+-----------+------+
| ticket_id | note |
+-----------+------+
| 1 | A |
| 1 | B |
| 2 | C |
| 3 | D |
| 4 | F |
| 5 | 0 |
| 3 | G |
| 2 | E |
+-----------+------+
8 rows in set (0.00 sec)mysql> SELECT A.* FROM `tbl_ticket_log` A
-> LEFT JOIN `tbl_ticket` B ON A.ticket_id = B.ticket_id
-> WHERE A.ticket_id IS NOT NULL
-> AND B.hidden = 0;
+-----------+------+
| ticket_id | note |
+-----------+------+
| 1 | A |
| 1 | B |
| 4 | F |
+-----------+------+
3 rows in set (0.00 sec)mysql> SELECT B.* FROM `tbl_ticket` A
-> LEFT JOIN `tbl_ticket_log` B ON A.ticket_id = B.ticket_id
-> WHERE A.hidden = 0;
+-----------+------+
| ticket_id | note |
+-----------+------+
| 1 | A |
| 1 | B |
| 4 | F |
+-----------+------+
3 rows in set (0.00 sec)*/为什么说是不可以的呢??
呵呵,如果是这样,
建议你还是升级到 MySQL 4.0.14a 吧,前些天,一个台湾的朋友也遇到了这类奇怪的事,他用是的 MySQL 4.0.6