search for: project_work_time

Hi all. I have 2 tables, one is work_times, and one is projects. I use a joint table to link 2 as they are has and belongs to many relationship . so there is a project_work_time. Now I need to add one column ''work_hours'' that is unique to each row of joint table project_work_time. I need to make a view such that for one specific work_time, it lists a series of projects and work_hours each projects is devoted on. If I left my hours inside joint table it...