Here is my sql query. what are my options ?
1. Do i need to create separate java class for each table ?
2. Why can't i create a class with all the selected fields [abstact] and run the regular SQL in session.find()?

Pardon me. This is my first hibernate attempt.

--------------------------------------------------------------------------
select l.zip_code, l.city, l.state, f.sky24, c.temperature,c.wind_speed, c.relative_humidity
from weather_location l, weather_forecast f, weather_current c
WHERE l.zip_code = 30346
and l.station_id = c.station_id
and l.location_id = f.location_id
and f.day_of_week = 2
order by l.zip_code;
---------------------------------------------------------------------------

Thanks
Raj