Try UNION ALL

>I'm trying to basically count data from 2 tables. I'm using a UNION command as such.
>
>sele cellcode,sum(IIF(betw(fdisp,"01","05"),1,0)) as sales,;
>sum(IIF(fdisp="01") as contacts,;
>sum(IIF(fdisp="01") as bad,;
>from table1;
>where curdate<="020505";
>group by cellcode;
>UNION;
>sele cellcode,sum(IIF(betw(fdisp,"01","05"),1,0)) as sales,;
>sum(IIF(fdisp="01") as contacts,;
>sum(IIF(fdisp="01") as bad,;
>from table2;
>where curdate<="020505";
>group by cellcode;
>
>Both tables are identical The problem is - I get duplicate cellcodes one below the other. Instead, I need the result summed up for both tables.