Hi Igor,
this worked out !!!! :)
Thank so musch for your help, and thank to all who answered my question
Have a nice new year
greetings from Rome,
Giulio
> Giulio Mastrosanti <[email protected]> wrote:
>> But the user can select to search for A records that MATCH ALL the B records
>> selected, in this case the A records that are linked
>> to ALL of record B with id 1, 2, 3
>>
>> I have arranged the query this way:
>>
>> select a_id from a_b where b_id in (1,2,3) group by a_id having count(b_id)
>> = 3
>>
>> this query returns only A with id 1, because checking if the count of the
>> rows grouped is equal to the number of the B ids
>> specifyed in the query, I have returned only the A records that are linked
>> to ALL the B records selected for the query.
>>
>> Now my problem is, that for a number of reasons now I can have an A record
>> linked to more than one records B with the same ID, so
>> I could have a table A_B filled this way:
>>
>> A_id | B_id
>> 1 1
>> 1 2
>> 1 3
>> 2 1
>> 2 2
>> 2 2
>
> select a_id from (select distinct a_id, b_id from a_b)
> where b_id in (1,2,3) group by a_id having count(b_id) = 3;
>
> Igor Tandetnik
>
>
Giulio Mastrosanti
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
