SQL: Connect by/Start with

From: <mkooloos_at_hotmail.com>
Date: Tue, 02 Feb 1999 14:34:56 GMT
Message-ID: <7972eg$49q$1@nnrp1.dejanews.com>

Can anybody tell me what's the difference about this statements AND WHY!!!

1st)

select mic.assembly_item_id


,      mic.component_item_id


,      mic.organization_id


,      level


from   mcg_inventory_components        mic
where  mic.organization_id             = 6
start with mic.assembly_item_id        = &assembly_id

connect by prior mic.component_item_id = mic.assembly_item_id

2nd)

select mic.assembly_item_id


,      mic.component_item_id


,      mic.organization_id


,      level


from   mcg_inventory_components        mic
start with mic.assembly_item_id        = &assembly_id

connect by prior mic.component_item_id = mic.assembly_item_id where mic.organization_id = 6

3rd)

select mic.assembly_item_id


,      mic.component_item_id


,      mic.organization_id


,      level


from   mcg_inventory_components        mic
where  mic.organization_id             = 6
start with mic.assembly_item_id        = &assembly_id

connect by prior mic.component_item_id = mic.assembly_item_id and mic.organization_id = 6

• PROBLEM *** The problem is the position of the where-cluase of the organization_id, and the differences in the results.

THANX, Michael.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 02 1999 - 08:34:56 CST