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
