[jboss-user] [EJB 3.0] - EJB 3.0 help - joining

i have two tables: categories_id BIGINT(20) NOT NULL, image VARCHAR(45) NOT NULL, parent_categories_id BIGINT(20) NOT NULL, sort_order INTEGER(3) NOT NULL, last_modified DATETIME NOT NULL, timestamp DATETIME NOT NULL, PRIMARY KEY(categories_id) ); CREATE TABLE categories_lang ( categories_id BIGINT(20) NOT NULL, languages_id BIGINT(20) NOT NULL, name VARCHAR(45) NOT NULL, description TEXT NOT NULL, PRIMARY KEY(categories_id, languages_id) ); in categoriesLang the languages_id is given... is it possible to get the specific language data while creating query for categories table... or have i ask second table in second query stephan View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3961714#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...