Lookup tables

2006-12-20 Thread Terry Jeske
Hello, I have been working some with Hibernate, and while I like a lot of what it has to offer, but I am constantly frustrated with things that would be a no brainier sql query, that takes hours if not days to try in shoehorn into their paradigm. Here is a scenario that you cannot do in

Re: Lookup tables

2006-12-21 Thread Terry Jeske
). projects_table id int (pk) projectname varchar status_id int (fkey to status_table id) status_table -- status_id int (pk) status_name varchar Andrus On Dec 21, 2006, at 2:34 AM, Terry Jeske wrote: projects_table

Re: Lookup tables

2006-12-21 Thread Terry Jeske
, 2006, at 2:34 AM, Terry Jeske wrote: projects_table id int projectname varchar status int status_table -- projectId int (fkey back to projects_table id) status_name varchar