Not like

[auburnfan]

Ver 9
Ok, I need to figure out what is not in {table.B} that is in {table.A}
Example
{table.A} {table.B}
1 1
2 3
3 4
4 6
5 7
6
7

I need the report to find that 2 and 5 are missing in {table.B}
any suggestions?

 

[synapsevampire]

Post your database type...

This looks like an excellent candidate for a MINUS type of query, ask your dba about them.

btw, most would phrase this as show everything in Table A that is not in Table B

An add command of:

select id from tablea
minus
select id from tableb

Or an Add Command of:

select id from tableA
where id not in
(select id from table b)

This is all theory, not a guaranteed match for your database becase again, you ask about data and queries but don't post what database you're using.

ALWAYS post your Crystal version and the database/connectivity used for the best responses, otherwise your saving the 10 seconds costs everyone more time, including yourself.

You can also do this within Crystal, but passing the right SQL to the database from Crystal is the way to go.

-k

 

[lbass]

Or you could use a left join FROM Table A to Table B and then use a record selection formula of:

isnull({tableB.ID)

-LB