creating a table/resultset of all clients specifying which other tables it exists in

[colmkav]

Hi, I have one table (called CLIENTS) with all the clients  in them plus a series of "rule" tables (eg rule01, rule02) with a selection of clients in each of them (determined according to whether they pass a given rule). I want to create a new table/resultset which contains all the clients and specifies which of the rule tables it appears in.

What is the best way to achieve this?

thx
Colm

[Lalit Mohan Pandey]

Hi colmkav,

Could you please tell us is series is another table and if it is then there any relation between both the tables or could you please upload the database with sample data for better understanding.

Regards,

Lalit Mohan