****************
resolved ... sorry (typo)
****************
Hello

i'am trying a request with 4 join and i got this error

The request :

String sql= " From AlerteSeasonsItunesPrices a , UserListTvShow u , Season s , SeasonItunesPrice sip ";
sql += " Where id_sip = sip.id ";
sql += " and id_season = s.id ";
sql += " and s.id_tvshow = u.id_tvshow ";
sql += " and id_user = 1";


Here my sql table
alerte_season_price(id , price_after, price_before, id_sip)
season_itunes_price(id ,... , id_season)
season(id , name , id_tvshow)
user_list_tvshow (id , id_tvshow , id_user)

if i use " and s.id_tvshow = u.id_tvshow ", i got the error
org.hibernate.QueryException: could not resolve property: id_tvshow of: com.nsa.n74.tvshowtrackerweb.hibernate.Season

if i use " and id_tvshow = id_tvshow ", i got the error
java.sql.SQLException: Column 'id_tvshow' in where clause is ambiguous


i'am quite sure i'am missing something, but i canno't find it

thanks for your help
Nicolas

Can you also post your mappings? It looks like you probably forgot to map the id_tvshow column, or maybe there is a typo in your mapping somewhere.