Hi everyoneI spend a long time to get this @ work: I have 2 dynamic tables. Created from sub tables with the same structure.INPUT TABLES:Table 1: clerk_admin_hour_access_guaranteed AS clerk_pos-------------------------------------------------------#clerk_id #clerk_name #hour-------------------------------------------------------1 Admin 201 Admin 11.42 Mauser 663 Whyskas 5.32 Mauser 0.11
...Table 2: clerk_admin_hour_access_guaranteed AS clerk_neg-------------------------------------------------------#clerk_id #clerk_name #hour-------------------------------------------------------4 Golf 19.22 Mauser 101 Admin 17.32 Mauser 0.2
...OUTPUT TABLE:The output must have list all clerks when there are in both tables. And then calculate sum(hour).Table 3: clerk_admin_hour_total_access AS clerk_sum-------------------------------------------------------#clerk_id #clerk_name #SUM_hour-------------------------------------------------------1 Admin 48.72 Mauser 76.31
I have tried a lot of queries. But in all ways I had the same probelm.Please help me with the query--Schareina