SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot
    Join Date
    Nov 2004
    Location
    Lytham
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Multiple unrelated table search

    I'm wanting to make a search facility for quite a large site
    and I was wondering if theres a way to search many unrelated tables
    with one SQL query.

    I have looked at UNION ALL but from what I can see this can
    only be used on 2 tables

  2. #2
    Tranceoholic lilleman's Avatar
    Join Date
    Feb 2004
    Location
    Írebro, Sweden
    Posts
    2,716
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    I am not sure if you can use joins in this case, but it might be worth a try?

    Yours, Erik.

  3. #3
    SitePoint Guru
    Join Date
    Jan 2004
    Location
    Uppsala, sverige
    Posts
    697
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)
    I have looked at UNION ALL but from what I can see this can
    only be used on 2 tables
    That's not true, you can have more than two.


Bookmarks

Posting Permissions

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