sammybee77
Technical User
HI All,
If tableA = TableB (+) (TableB has multiple rows) I want to find all records in A where TableB.Field1 = 12 but <> 15. The problem is that for every ID of 12 there should be another ID of 15 I want to find those that don't have a match. E.g. For the row in Table A , Table B may contain 5 ID's of 12 and 4 ID's of 15 So I would want that to appear on the report, but if Table B contained 5 IDs of 12 and 5 ID's of 15 I wouldn't want that row to appear in the report.
Any Ideas?
Many thanks
Sam
If tableA = TableB (+) (TableB has multiple rows) I want to find all records in A where TableB.Field1 = 12 but <> 15. The problem is that for every ID of 12 there should be another ID of 15 I want to find those that don't have a match. E.g. For the row in Table A , Table B may contain 5 ID's of 12 and 4 ID's of 15 So I would want that to appear on the report, but if Table B contained 5 IDs of 12 and 5 ID's of 15 I wouldn't want that row to appear in the report.
Any Ideas?
Many thanks
Sam