Thanks for your feedback.
By the way, I found the following to be the way to go.
Original
> 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
New:
Select *
>From group_mstr gm
Right outer join grou_payers gp on
( gp.location_id = '2'
and gp.practice_id = gm.practice_id
and gp.group_id = gm.group_id
)
Where
gm.practice_id = '1'
When compared to the suggestions, notice how I had to keep the
qp.location_id in the on portion to keep them equivalent.
Regards,
Adam
Adam Trimeloni
Project Leader
Quality Systems
[EMAIL PROTECTED]
(949) 255-2600
-----Original Message-----
From: Trimeloni, Adam
Sent: Thursday, February 15, 2007 2:32 PM
To: 'Gary W. Smith'; Dan Nelson
Cc: mysql@lists.mysql.com
Subject: RE: SQL Translation
I should have mentioned it is a short hand for a join.
*= is a left outer join.
=* is a right outer join.
Adam Trimeloni
Project Leader
Quality Systems
[EMAIL PROTECTED]
(949) 255-2600
-----Original 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'
> > 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). You should be able to do the same in mysql with
Isn't that the Oracle syntax for join? I didn't think that was
supported in SQL 2000
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
