Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: Multiple Tables

  1. #1
    New to the CF scene
    Join Date
    Mar 2006
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple Tables

    Hi!

    i'm having a proble with regards to my search.

    i want to search multiple tables using a keyword.

    those tables doesn't have relationship or doesn't have similarities...how can i perform my search?

    thanks in advance.

    i'm using SQL Server 2005

  • #2
    Senior Coder
    Join Date
    Sep 2005
    Posts
    1,791
    Thanks
    5
    Thanked 36 Times in 35 Posts
    some more information would help (the columns in the tables, and then which ones you want to search), if the tables aren't in anyway connected, why are you wanting to search them as if they were?

  • #3
    New to the CF scene
    Join Date
    Mar 2006
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    i'm creating a page on which a user can search using a keyword anywhere in the database.

    The thins is i wasn't the one who designed the database. If i we're going to re design the database, it will take time, and i doesn't have that much.


    thanks for your reply.

  • #4
    Senior Coder
    Join Date
    Sep 2005
    Posts
    1,791
    Thanks
    5
    Thanked 36 Times in 35 Posts
    That's just silly. Why would a user want to search for something anywhere in the database, and more to the point, why would you want to let them?


  •  

    Posting Permissions

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