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?
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.