The community was very helpful to me to get a query built for Toad Datapoint with a Vertica database. I can get the query to run, but the output data/results is different for the same data that inputted to the older Toad for Oracle database. I have been trying to find out why and have not made progress.
The present sql has 2 subqueries and each subquery has 3 inner joins. I need data from 6 different tables. If 1 run just one of the subqueries stand alone, it is the same data as when I run ther complete sql. If I run just the data for any of the individual tables by itself, the data matches 100% to the Toad for Oracle. To me it is not a subquery issue, but more of a inner join issue.
The other part is trying to get a formula to obtain a Success Ratio.
THANKS in advance