Re: [GENERAL] Hint for a query

2011-11-04 Thread Uwe Schroeder
> I have this tables > > > Table: Contact > IdContact > First Name > Second Name > … other columns > > Table: Employee > IdEmployee > IdContact, related to Contact table > … other columns > > Table: Salesman > IdSaleman > IdEmployee, if salesman is employee, related to Employee table > IdCont

Re: [GENERAL] Hint for a query

2011-11-03 Thread David Johnston
On Nov 4, 2011, at 0:37, Efrain Lopez wrote: > I have this tables > > > Table: Contact > IdContact > First Name > Second Name > … other columns > > Table: Employee > IdEmployee > IdContact, related to Contact table > … other columns > > Table: Salesman > IdSaleman > IdEmployee, if salesman is

[GENERAL] Hint for a query

2011-11-03 Thread Efrain Lopez
I have this tables Table: Contact IdContact First Name Second Name … other columns Table: Employee IdEmployee IdContact, related to Contact table … other columns Table: Salesman IdSaleman IdEmployee, if salesman is employee, related to Employee table IdContact, if salesman is not an employee, r