>Tables exist SQL2000 or SQL2005:
>
>I have 2 string values: thisform.pcInci_Id and thisform.pcParent_Id
>I want to pull all records from one table whose inci_id value exists in a result from another table
>
>

>Long Way:
>
>1.  Retrieve table1.inci_id field from all records in table1 where
>       table1.inci_id = thisform.pcInci_Id
>       or table1.inci_Id = thisform.pcParent_Id
>       or table1.parent_id = thisform.pcInci_Id
>       or (LEN(table1.parent_id)>0 AND table1.parent_id = thisform.pcParent_Id)
>
>2.  Get all fields in all records in table2 where
>       table2.inci_id is in (the cursor result created in step 1)
>

>
>For some reason I am stumped on the short way! Any ideas?

select * from Table2 where exists (select * table1 where
       table1.inci_id = thisform.pcInci_Id
       or table1.inci_Id = lnParm1  or table1.parent_id = lnParm2
       or (LEN(table1.parent_id)>0 AND table1.parent_id = lnParm2))