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

SELECTFROM <table_name1>,<table_name2> 
WHERE <column_table1>=*<column_table2>

Microsoft SQL Server 2008

SELECTFROM <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” 

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.