Following my post about this complex search I'm trying to do...
In the initial post I said I'd tried adding:
left join table_ga as tga on tga.id = r.id
left join table_a as ta on ta.ida = tga.ida
or:
left join (table_ga as tga inner join table_a as ta) on
(tga.id = r.id and ta.i
At 16:09 +0100 11/5/06, I wrote:
Not long ago, some highly knowledgeable people here kindly helped me
out with a fairly complex query...
...
That's all fine and dandy, but now I need to extend this to a
further four tables...
What I should have added is that for the moment this has to be
p
Not long ago, some highly knowledgeable people here kindly helped me
out with a fairly complex query...
Finding names of people (and other info) where one or more fields
match the search string in up to five tables (abstracting somewhat):
select distinct
id, firstname, lastname,