Thank you all. It helps a lot!!!

It is pretty close!

The reason for 61 not support to return bacause:

1. The M 61 does have two groups which are exect the same as it assoicated catgory

2. Hower the...

What I exect is something like

Select record_id

from Security_assignement

Join....

where ........

The the return is

494

Thanks!

Bacause from business operation, if the Matter and its assoicated Category assigned with exact groups, there is something wrong. That's why I need find all of those Matter(s).

It is not...

How can I write a query to find out the record of 494 from Security_assignement table?

Bacause 494(Matter) has relatitionship with 12406(category), and both of them has exact groups associciate with...

How can I create a qurey to find the record like 494 in security_assignement table. Bacasuse it has exactly records of group numbers as it asssociated Category(12406)

Matter 494 related with...

Sorry my lazy work and thank a lot the patient!

here is the script

CREATE TABLE [dbo].[matter](

[matter_id] [int] NOT NULL,

[category_id] [int] NOT NULL,

[r_type] [char](1) NOT NULL

)

insert into matter (matter_id, category_id, r_type)

values

(61,...

First, thanks again all respondings!

Second this is not a homework from school. I greatly simplified the table structure. We have a security setup challenge. I need to find out...

Thanks your both's responding!

The Matter has relationship with Category.

The goal it to find the record which the Matter and Category(this category related with the Matter) has exact the Group(s) assignment...

You are all correct!

The third table has duplics.

If the third table has duplics, is that possible eliminated the duplic return?

Sorry, my initial information didn't provide the accurate situation.

Thanks,

Here is what I received:

John Anderson, City1, 55555

John Anderson, City2, 66666

John Anderson, City1, 77777

John Anderson, City2, 88888

Mary Anderson, City1, 55555

Mary Anderson, City2, 66666

Mary Anderson, City1, 77777

Mary Anderson, City2, 88888

Thanks!

Same as Ian. thanks again!

Great to understand those two different tools more.

Thanks a lot!

That's exactly what I am looking for and thank a lot!

In this case, there is no reason to use VS for report. Is that true?

Thanks!