Making a SQL 2000 SP - SQL 2005 Compatible

• vchenne

  Newbie

  Points: 5

  More actions

  February 8, 2008 at 7:09 am

  #69783

  I am finding difficult to translate the below query to replace

  *= with LEFT OUTER JOIN Syntax.

  Idea is to make it SQL 2005 Compatible.

  SELECT count(*)

  FROMt_Prod,

  t_Prod1 l,

  t_Prod2 l_sku,

  t_Prod3 l_type

  WHERE t_Prod.SKU *= l_sku.SKU and

  t_Prod.SKU_Type_ID *= l_type.SKU_Type_ID and

  l.Code *= l_sku.Code and

  l.Code *= l_type.Code and t_Prod.SKU = 1

  Thanks in Advance.

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  February 8, 2008 at 7:20 am

  #776414

  Can you give us some sample data from t_Prod, 1,2 and 3? as well as some sample results?

  ______________________________________________________________________

  Personal Motto: Why push the envelope when you can just open it?

  If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

  Jason L. Selburg