if i have five tables, and i have to change values in first table whose columns are depended on these four tables. which query is batter and good? this one....?
select A.id as folder_id,
A.name as folder_name
from mst_folders A join mst_folder_requests B
on A.id = B.folder_id
where B.user_id = @employeeId
and B.wfitem_id in
(select item
from mst_wfitem_action_map
where item in
(Select ID
from mst_wfitems
where type = @WorkflowId and wfevent_id in
(select id
from mst_wfevents
where type_id = @EventTypeId
and user_id = @employeeId)
)
and actor = @actorId and state = 'P')
or this one?
select A.id folder_id,
A.name folder_name
from mst_folders A
join mst_folder_requests B on A.id=B.folder_id
join mst_wfitem_action_map C on B.wfitem_id = C.item
join mst_wfitems D on C.item=D.id join mst_wfevents E on D.wfevent_id=E.id
where B.user_id=@employeeId
and D.type=@WorkflowId
and E.type_id=@EventTypeId
and E.user_id=@employeeId
and C.actor=@actorId and C.state='P'
