Re^4: perl sql to separate and sort the column separately?

Replies are listed 'Best First'.
Re^5: perl sql to separate and sort the column separately? by robby_dobby (Hermit) on Apr 12, 2017 at 09:04 UTC
Hello gpssana, Your expected and actual output are just one part of it. We also expect some code that we can execute in an isolated manner to reproduce your results. In your case, your sql only says that you're querying for some columns, performing an `UNION ALL` to collapse results with another subquery. That doesn't tell us how your data is structured. Depending on your data, your query may be the culprit or you may have used a different DBI method call. We don't see that yet. Also, take a look at Corion's reply here.	[reply] [d/l]
Re^5: perl sql to separate and sort the column separately? by Corion (Patriarch) on Apr 12, 2017 at 08:58 UTC
But you don't show us a short, self-contained program that we can run to reproduce your problem. Especially, as I think that your problem is in your SQL, you will need to change the SQL that produces your output.	[reply]