intested of "INTERSECT"

• SreenivasaRao

  SSC-Addicted

  Points: 499

  More actions

  October 23, 2006 at 1:13 am

  #117219

  Hi

  all Iam have query with "INTEREST"operator this is Oracle specifc

  Insted of intersect i want other alternative which is ahaving eligibility to work both oracle and Sql Server

  can some help me on this issue

  Thanks in Advance

  SreenivasaRao

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  October 23, 2006 at 2:00 am

  #667295

  You nned, probably, read what INTERSECT is for and than look for this functionality in BOL or ask here.

  _____________
  Code for TallyGenerator

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  October 23, 2006 at 3:07 am

  #667304

  Also asked and answered here

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73899

   

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  October 23, 2006 at 3:27 am

  #667307

  Also answered cople of times on this forum

  _____________
  Code for TallyGenerator