SQL or Crystal exclusion query statement

[TerraSapient]

Shot in the dark, but anyone out there familiar with querying SQL or Crystal databases that can help me write a statement to select records in one table that are not associated to another table?

Details:
Table 1 is an asset record table
Table 2 is a work routine table
I need to select all assets in Table 1 that do not have values in Table 2.

I have been trying null statements, but haven't had any luck.
I already have established the link between the tables in crystal, and I have run a report that shows me all assets that are included in a work routine, but I cannot get the ones that are not included in a work routine.

Words of wisdom appreciated.

[Linda_D]

In SQL, try NOT EXISTS or NOT IN ...

STACKOVERFLOW.COM gives a good explanation of both and why NOT EXISTS is probably better ... NOT IN vs NOT EXISTS

[TerraSapient]

I tried a left outer join between table 1 and table 2 with
{table1.record} isnull {table2.record}

But I kept getting an error message stating that table 2 wasn't part of the equation.

For some reason crystal doesn't support not exist or not in.

Thanks for the tip though Linda_D! I will put that one in my pocket for later.

Any other ideas?


Edit: I got it! For the record, if anyone in the future is trying to do this you use the select expert and run the same statement I have above, but like this:
{table1.record}
isnull ({table2.record})