>
>
>
>BTW, unless one of these tables has only one row, you almost certainly
>want to add a WHERE clause to your query, something like
>
> WHERE tr.thiscolumn = conv.thatcolumn
>
>Servus
> Manfred
>
>
Hi, this tip from Manfred is very important.
If you do not do that, you will get any possible combinations of
the rows of
the 2 tables, so if both tables have 100 entries, you would get
10000
results,
while most of them don't make any sense.
Think of a join of 3 tables containing 1000 rows each: you would
get a
result of 1000'000'000 rows, this can slow down your server quite
a bit...
Cheers, Dani