Database View 4 Tables?

[Steve A]

I am working on a bar chart report that may require up to 4 tables in a database view and I am struggling to understand if it can be done. The report starts with the out of the box join between task_sla and incident tables to group business elapsed time into report ranges. the problem comes in the related tables from the incident table. I would normally dotwalk from incident table to the location table and then using a user defined field u_pc_profile in the locations table to a user defined table u_pc_core to find the division field. Because the sla table is the only one I know of that has elapse time calculated I beleive I must use database view. If this is rue then how to I add the locations and PC Core tables so I can group by division?

Thank you for any help or options. Below is what I have so far but I am getting an error

[Jon Barnes]

It may help to set your order. Right now they are all 100, but set them so that it starts with SLA, then incident, then location, then your custom table. Let me know if you are still getting an error after that.

[Steve A]

So I think I figured it out. Because the location field is extended from the task table into the incident table I could not created the join from the location table sys_id to that incident filed. I went back and rebuilt the view using the task table and I was able to get it all working. I also now understand why order is important since i the View will step though the joins and if they are out of sequence or not defined the join could fail or present data that is incorrect. at one point all of my incidents had the same location. Thanks