Форум пользователей MySQL

Здравствуйте!
Раньше стоял SQL Server 2000 и этот скрипт работал на SQL Server 2008 шибка выетает.
Очень жду помощи, так как отчеты 15 числа нужно делать помощью его.
Жду ответа!!!
Вот код скрипт, а в низу текст ошибки

select
o.id as 'ID','@',
o.initials as 'FIO','@',
p.birthdate as 'DR','@',

'ЉЂЌ‘Љ' as 'PUNKT','@',

s.name as 'г«Ёж*','@',
b.bldn_no as '*®¬Ґа ¤®¬*','@',
f.flat_no as '*®¬Ґа Єў*авЁал','@',
'08.2003' as 'otch','@',
o.really_live as 'SEM','@',
f.total_sq as 'PL','@',
c.norma as 'PLS'


from occupations o, flats f, consmodes_list c, buildings b, xstreets s, people p

where o.flat_id=f.id and

c.occ_id=* o.id and
c.service_id='Ї«®й'and
o.flat_id=f.id and

b.id=f.bldn_id and
s.id=b.street_id and

p.occ_id=o.id and
p.who_id='®вў«'


.Net SqlClient Data Provider: сообщение 4147, уровень 15, состояние 1, строка 22
The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80, using the SET COMPATIBILITY_LEVEL option of ALTER DATABASE. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes.