Message-
From: Gary W. Smith [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 15, 2007 2:19 PM
To: Dan Nelson; Trimeloni, Adam
Cc: mysql@lists.mysql.com
Subject: RE: SQL Translation
> > Select *
> > from group_mstr gm,group_payers gp
> > where gm.practice_id = '1'
&g
, 2007 2:19 PM
To: Dan Nelson; Trimeloni, Adam
Cc: mysql@lists.mysql.com
Subject: RE: SQL Translation
> > Select *
> > from group_mstr gm,group_payers gp
> > where gm.practice_id = '1'
> > and gp.location_id = '2'
> > and gp.practice_id =* gm.practice_
> > Select *
> > from group_mstr gm,group_payers gp
> > where gm.practice_id = '1'
> > and gp.location_id = '2'
> > and gp.practice_id =* gm.practice_id
> > and gp.group_id =* gm.group_id
> > order by gp.payer_id
>
> I bet =* is shorthand for an outer join (not sure if it's left or
> right). Yo
In the last episode (Feb 15), Trimeloni, Adam said:
> I am currently working on a project to support using a MySQL database
> along with SQL Server 2000. The following query has me stumped:
>
> Select *
> from group_mstr gm,group_payers gp
> where gm.practice_id = '1'
> and gp.location_id = '2
I am currently working on a project to support using a MySQL database
along with SQL Server 2000. The following query has me stumped:
Select *
from group_mstr gm,group_payers gp
where gm.practice_id = '1'
and gp.location_id = '2'
and gp.practice_id =* gm.practice_id
and gp.group_id
