Using PIG with complex SQL Statement

[Vineet Mishra]

Hi,

I was looking out to transform SQL statement which is consisting of
multiple clause in the same query specifically, a JOIN followed by some
condition(WHERE) and finally grouping on some fields(GROUP BY).
Can I have a link or some briefing which can guide me how can I implement
this k/o of complex SQL statement in PIG.

Thanks!