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#3961714 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3961714 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
