Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Norway
    Posts
    4

    Question Unanswered: Without a sub query...?

    Hi!

    I've got to do the equivalent query to the one below without using a sub query. How do I do that?

    SELECT Merchandise.number
    FROM Merchandise
    WHERE Merchandise.text=
    (SELECT Merchandise.text FROM Merchandise
    WHERE Merchandise.number = x)
    MINUS
    SELECT Merchandise.number FROM Merchandise
    WHERE Merchandise.number = x;

    Thanx in advance...

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    Sounds like homework to me.

    Look up anti-joins and anlytics.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Feb 2004
    Location
    Norway
    Posts
    4
    Originally posted by The_Duck
    Sounds like homework to me.

    Look up anti-joins and anlytics.

    You're absolutely right...homework!

    But I'll look into your advice.

    Thanx.

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    you realize you won't get anything returning from that query?

    you want everything that is 'x' and then you DON'T want everything
    that is 'x'
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •