I have two tables as below.

 

 

Acct #  Item #   Order #     Qty Sold

1         x1          452             1

1         x3           453             1

2          x1          455              1

 

 

Item No      Description

X4              Cloth            

x1               spoons

I need to get a list of cutomers who have not bought any one of the listed items in Table 2 and display the same agaist the customer name.  I will be linking the tables 1 and 2 throgh a left outer join on item Number in both the tables.

 

In the above exapmle i want to display the folloiwng

 acct #      Item no     Description

  1             X4             CLOTH

  2             X4             CLOTH

Any help would be appreciated.

 

Hem Reddy

 

 

 

Hem Reddy

 

Placed the Item No from table 2 in the detail section and added the isnull formula to the selection expert. Still getting a blank on the report.

 

Hem Reddy

 

Yes i am able to get the data now. I show matching records.

 

Hem, Reddy

 

I think i explained the situation in wrong way. The Table 1 has more items than the table 2. Table 2 has just 15 items. Table 1 on the other hand has about 200.

If i change the jon from Table 1 to Table 2 then see nulls for column for teble 2 item number.

Hem Reddy