Ispirer Website
Ispirer Capabilities - Microsoft SQL Server Migration
Free Trial
Right Join
Joins in non-ANSI format should be upgraded to ANSI format.
Microsoft SQL Server 2000
SELECT … FROM <table_name1>,<table_name2> WHERE <column_table1>=*<column_table2> …
Microsoft SQL Server 2008
SELECT … FROM <table_name1> RIGHT OUTER JOIN <table_name2> ON <column_table1>=<column_table2> WHERE …
Example:
Microsoft SQL Server 2000:
SELECT shop_name FROM shop, customer WHERE shop.good_id=*customer.good_id AND shop.good= “Milk”
Microsoft SQL Server 2008:
SELECT shop_name FROM shop RIGHT OUTER JOIN customer ON shop.good_id=customer.good_id WHERE shop.good= “Milk”