subject:"\[SQL\] Help With complex join"

Re: [SQL] Help With complex join

2005-07-15 Thread Richard Huxton

[EMAIL PROTECTED] wrote: Hi all, got a question as how to approach a somewhat complicated join query. The deal is I have three tables called attorney, lawOffice, and law_office_employment. The attorney and lawOffice tables hold attorney and lawOffice information respectively (obviously). The l

Re: [SQL] Help With complex join

2005-07-14 Thread Gnanavel S

On 14 Jul 2005 14:34:02 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED] > wrote:Hi all, got a question as how to approach a somewhat complicated join query. The deal is I have three tables called attorney, lawOffice, andlaw_office_employment. The attorney and lawOffice tables hold attorneyand lawOffi

[SQL] Help With complex join

2005-07-14 Thread spinto

Hi all, got a question as how to approach a somewhat complicated join query. The deal is I have three tables called attorney, lawOffice, and law_office_employment. The attorney and lawOffice tables hold attorney and lawOffice information respectively (obviously). The law_office_employment table