2011/03/15 17:51 -0500, LAMP
Let's say there is a table orders (simplified, of course)
CREATE TABLE orders (
item_id int,
org_id int,
) ENGINE=MyISAM
Need to select all (distinct) org_id they have item_id 34, 36, 58 and
63. All of them, not only some of them.
Result is org_id=2607 and
CONNX Webinar
Learn about integrating all of your enterprise data into MySQL databases.
CONNX is easy to install and easy to use, yet sophisticated and powerful enough
to solve all of your enterprise wide integration needs through a single product.
The CONNX platform integrates MySQL with more
I have 3 tables
Table ³groups²
groupid, groupname
Table ³agmap²
groupid, articleid
Table ³articles²
articleid, articletopic, articlebody
The relation is that articles can have groups attached to it via the map
table. I can insert this and work it out fine. The issue is when I want to