Man of Honour
a chap I've been working with never uses Inner, or outer joins, let, right joins, but instead relies on self joins.. for example..
<code>
SELECT column_name(s)
FROM table1 a, table1 b, table c
WHERE a.client = b.client and a.client = c.client and b.country = c.country </code>
Now I'm wondering is there a performance issue using this kind of technique?
<code>
SELECT column_name(s)
FROM table1 a, table1 b, table c
WHERE a.client = b.client and a.client = c.client and b.country = c.country </code>
Now I'm wondering is there a performance issue using this kind of technique?