hi, I need your help, I have a database, reported very bad, however I have to do a query like this: "Select from cd.descrizione reparticolo ra, coloridescr cd = WHERE cd.colori_id ra.colori_id and cd.mercati_id = 2 and ra.codice = 345475 ";

PS: The two tables are not related, and I have already created the mapping of the two tables, with no report, because of colori_id reparticolo is not the primary key and I can not create it.
Can someone tell me how can we do with NHibernate?

Thanks, I'm really desperate