- or download this
mysql> desc poll;
+-------+------------------+------+-----+---------+----------------+
...
| id | int(10) unsigned | | PRI | 0 | auto_increment |
| poll | varchar(50) | | | | |
+-------+------------------+------+-----+---------+----------------+
- or download this
mysql> desc poll_votes;
+---------+------------------+------+-----+---------+----------------+
...
| poll_id | int(10) unsigned | | | 0 | |
| address | varchar(50) | | | | |
+---------+------------------+------+-----+---------+----------------+
- or download this
mysql> select * from poll;
+----+--------+
...
| 2 | 2 | junk |
| 3 | 2 | morejunk |
+----+---------+----------+
- or download this
select p.poll
from poll p
left outer join poll_votes pv
on pv.poll_id=p.id and pv.address='junk'
where pv.poll_id is null;
- or download this
+------+
| poll |
...
| C |
| C++ |
+------+