Oh sorry,
in my posted version of the Query i forgot a Group by clause. the Query that i have
used is:
select data.name from data, dat2cat where data.pk_data =
dat2cat.fk_data and (dat2cat.fk_category=44 or dat2cat.fk_category = 18)
group by data.name having count(data.name) > 1;
Simon Klaibe
Hi,
I have 2 Tables one with the data (lets call the Table Data) and one with Category
information (let's call it Category). I have a third Table (dat2cat)
with FK_Data and FK_Category that i use to assign up to n categorys to each Dataset in
Data.
I now want to get a list of datasets with ju