Results 1 to 6 of 6

Thread: SQL Join? ***Resolved***

Threaded View

  1. Nov 29th, 2002, 05:50 AM #1
    danielsan
    danielsan is offline

    Thread Starter
    Lively Member
    Join Date
    Oct 2002
    Location
    behind a pc
    Posts
    117

    SQL Join? ***Resolved***

    I have the following problem:

    a searchstring seperared by "+" or ",". Something like:

    me+you+we

    Table:

    Index IDCode name
    1 1 we
    2 1 me
    3 2 me
    4 2 you
    5 2 we
    6 3 we
    7 3 you

    I want to select only the IDCode that has all the names from the string. I have created some code to do this, but it is rather long. Is it possible to create a query who can do this and how?

    Thanks for the answer,

    danielsan
    Last edited by danielsan; Nov 29th, 2002 at 07:19 AM.
    Regards,

    danielsan

    'Even though the book is finished. There's no need to close and forget.'
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width