0

I have inserted different values into different temp tables. For example Salesman wise sold particular product. Product wise I have inserted to temp table.

But while getting data from temp table with join I am taking reference of first temp table. In case the second salesman is not avail on first temp table am not getting accurate result

Help me to resolve this issue!!!!

Regards

Harikrishnan

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user1826364
  • 1

1 Answers1

0

Change your inner join to the first temp table, to be an outer join.