free text search

Results 1 to 2 of 2

Thread: free text search

  1. #1
    Join Date
    Dec 1969

    Default free text search

    i need help for free text search which searches multiple tables like books, authors and countries but return a book title once.<BR>I tried putting all fields in one field by concanating the fields. It works for one table but when it comes to more tables it gives me multiple records of same book title.

  2. #2
    Sathiya Guest

    Default RE: free text search

    Add DISTINCT in your select query

Posting Permissions

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