5 Replies Latest reply on Feb 10, 2011 12:56 PM by Sven W.

    extracting unique records from two different tables record

    Raakh
      Hello,

      In the following code of two different tables www.testing.com exists in both tables. I want to compare two different columns of the two different tables to get unique records.
      SQL> select unique(videoLinks) from saVideos where sa_id=21;
      
      VIDEOLINKS
      -----------------------------------------------------------------------
      www.testing.com
      
      SQL> ed
      Wrote file afiedt.buf
      
        1* select unique(picLinks) from saImages where sa_id=21
      SQL> /
      
      PICLINKS
      -----------------------------------------------------------------------
      test
      test14
      www.hello.com
      www.testing.com
      Thanks & best regards