bit manipulation - SQL Logical AND operator for bit fields -

I have 2 tables that have many relationships; A person can be a member of many groups There may be many people in one group

Individuals have basically just their primary key ID

A primary key ID of the group, personal ID (Individual table has the same ID), and there is a little flag for that group in the primary group for the person

In principle, all the groups in the table, one of the entries of the entries are false., Because each person must have a primary group.

I know that for my current dataset, this belief does not hold true, and I have some people who have the primary flags for all our groups false.

I

The closest I have found is:

I leave personally to SELECT * GIIDIID = i .ID WHERE g.IsPrimaryGroup = 0

but does not work more than SUM or MAX, because the area is a little area, and is not a numerical.

Any suggestions?

Your data does not know ... but ... there is a participant in that left zone

What happens when you leave the WHERE and

  SELECT * individually, leaving the group live on G I.id and g.IsPrimaryGroup = 0  

Try to run on it .... Surely Unchester Since you did not give enough data

 < Select> code> SUM (Int, G Imperial Group)), i.id leaving the personal I [group] live on G. Individual ID = i.id and GI preferences are grouped by group = 0. Counting numbers (*) & gt; 1