You have a typical hierarchical data issue, can be solved with a graph.
Theory review: http://www.algorithmist.com/index.php/Graph_data_structures
Mysql and PHP implementation:
http://www.phpro.org/tutorials/Managing-Hierarchical-Data-with-PHP-and-MySQL.html
what about
select customers.* from customers left join calls on
(customers.date=calls.date) where customers.date="02/28/12";
of course date should be an index in both tables.
I think it migth work
On Wed, Feb 29, 2012 at 4:54 PM, LUCi5R wrote:
> JW,
>
>
>
> I'm trying to understand LEFT JOIN
I use the soundex algorithm to generate a 4 characters fingerprint of the
phonetic sound of a string, then I create an index over that field and
serch for it.
But soundex has an "issue"... the soundex fingerprint should be the same
for victor than for bictor, but since the soundex index uses the