Re: Alternatives to performing join on normalized joins?

2005-07-25 Thread SGreen
Siegfried Heintze [EMAIL PROTECTED] wrote on 07/24/2005 11:35:36 AM: I have a large number of job titles (40K). Each job title has multiple keywords making a one-to-many parent-child relationship. If I join job title with company name, address, company url, company city, job name, job

RE: Alternatives to performing join on normalized joins?

2005-07-25 Thread Siegfried Heintze
to performing join on normalized joins? Siegfried Heintze [EMAIL PROTECTED] wrote on 07/24/2005 11:35:36 AM: I have a large number of job titles (40K). Each job title has multiple keywords making a one-to-many parent-child relationship. If I join job title with company name, address, company url

Alternatives to performing join on normalized joins?

2005-07-24 Thread Siegfried Heintze
I have a large number of job titles (40K). Each job title has multiple keywords making a one-to-many parent-child relationship. If I join job title with company name, address, company url, company city, job name, job location, job url (etc...) I have a mighty wide result set that will be repeated