Dear all
I have two table, containing company info, and company employees, let's say (tables) 'Comp_list' and 'Comp_Emp'
In 'Comp_list' we have a field called 'Comp_list.Comp_name' and in 'Comp_Emp' we have a field 'Comp_Emp.Employer'
I want my query to just return those companys in 'Comp_Emp.Employer' where the company name equals or is like the comany name held in 'Comp_list.Comp_name'
I've tried various permutations of joins but the query never returns what I expect...
Any/all help greatly appreciated..
/pah
I have two table, containing company info, and company employees, let's say (tables) 'Comp_list' and 'Comp_Emp'
In 'Comp_list' we have a field called 'Comp_list.Comp_name' and in 'Comp_Emp' we have a field 'Comp_Emp.Employer'
I want my query to just return those companys in 'Comp_Emp.Employer' where the company name equals or is like the comany name held in 'Comp_list.Comp_name'
I've tried various permutations of joins but the query never returns what I expect...
Any/all help greatly appreciated..
/pah