create table City (
id long;
cityName char(50);
)

create table Country (
id long;
countryName char(50);
)

I want the SQL:
select * from City city, Country country
where cityName like countryName

How can I do this with DetachedCriteria??
I want the solution ONLY WITH DetachedCriteria....

Plz very urgent :((

Hey
Any answer???
Is all here beginners :)))

yup, I am also beginner.

As I know, it just can be done with HQL or SQL native only