From: livejavabean (livejavabeanyahoo.com)
Date: Thu Feb 10 2005 - 16:47:24 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi there..

Hope you can give me some thoughts on this. let say we have 3 tables

table 1 (pk=project_id)
=======
- project_id
- project_name

table 2 (pk=project_id, project_state_flag)
=======
- project_id
- project_state_flag (fk to state_flag)

table 3 (pk=state_flag)
=======
- state_flag
- state_flag_name

thank you.. but do u think it is possible to make the query return:

- 1 row per project
- each project state row's state become a column
e.g.

project 1, name, state a, state b, state c...
project 2, name, state a, state b, state c.

thanks in advance..

regards,
-ljb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]