Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2010
    Posts
    20

    Unanswered: Select shop sales which intersect

    Hi all,

    Been trying various Joins etc but with no luck.

    In english:

    Show me all common items which have been sold by shop A and Shop B within the last month.

    So if Item 100 was sold in shop A and Shop B I want it in my result set but not those
    items that were only sold in one shop or the other.

    Make sense ?

    TIA

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Um...INNER JOIN?

    If the data for all shops in a single table then there is another method without a join.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2010
    Posts
    20
    Thanks pootle

    I am having a numpty moment. Off to RTFM.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Post what you've got so far.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Jul 2010
    Posts
    20
    Cheers Pootle but I am having a real idiot moment.

    I have come down to throwing INNER JOINS at the screen in the vague hope I hit the right one. :-)

    I will work on it when I am fresh tomorrow.

    Most of the things I try end up as Cartesian Products.

Posting Permissions

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