About Re-write complex SQL query

[shule ney]

*Hi all:
Is there any software or website which can rewrite complex query with
sub-query in the WHERE clause to be in the FROM clause?? So that it can be
supported by HIVE.*



*Best Regards*

*Eugene z. Von*