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 =* gm.group_id order by gp.payer_id Does anyone know how to properly convert this to use ANSI joins instead? I converted others, but am having trouble this with one. In our test case, the group_payers table does not have a location id equal to 2. Yet, it still returns a row but populates all the group_payers columns are NULL. After our translation attempts returns no rows. (I am running the test cases in SQL Server 2000 first, to show our changes will still work with the current setup) Thanks, Adam
