Sql puzzle

[SG]

Hi all,
I have a sql puzzle (which I've solved) but seems very unwieldy. Is
there a more efficient way of doing this?
It reads like so:
SELECT a.*
FROM axindex a INNER JOIN
axindex b ON a.id4 = b.id4 AND a.id1 = b.id1 AND
a.id5 = b.id5 AND a.conflict_type = b.conflict_type INNER JOIN
axindex c ON b.id4 = c.id4 AND b.id1 = c.id1 AND
b.id5 = c.id5 AND b.conflict_type = c.conflict_type INNER JOIN
axindex d ON c.id4 = d.id4 AND c.id1 = d.id1 AND
c.id5 = d.id5 AND c.conflict_type = d.conflict_type
WHERE (a.stext = 'land') AND (b.stext = 'reg') AND (c.stext =
'fees') AND (a.conflict_type = 5) AND (d.stext = 'hamilton')
Many thanks in advance.
Sam

[David Portas]

Replied in microsoft.public.sqlserver.programming. Please do not post
the same question independently to different groups.

--
David Portas
SQL Server MVP
--