Thanks Kevin, that looks awful familiar - I think Boris wrote a similar example. Sheesh, ever have one of those days? :o)
>You need the alias OUTSIDE the parenthesis for the derived table. The 'tbl1' inside the derived table won't help outside the parenthesis. Try this...
>
>
>SELECT * FROM table1 AS tw INNER JOIN
> (SELECT table2.inci_id FROM table2 WHERE table2.inci_id = '07000244 '
> or table2.inci_Id = '2007093878 '
> or table2.parent_id = '07000244 '
> or (LEN(table2.parent_id)>0 AND table2.parent_id = '2007093878 ')) tbl1
> ON tw.inci_id = Tbl1.inci_id ORDER BY tw.inci_id, tw.vehnum
>
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"