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<!-- ~MESSAGE_AFTER~ -->
FAQ
Profile
Private Messages
Log in
