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]