Results 1 to 3 of 3

Thread: Searching

  1. #1
    Join Date
    May 2007
    Posts
    24

    Searching

    Hi,

    I have a table workorder and a table category.

    workorder.category (String) which holds the name of the category.
    category.department (String) the department the category belongs to.

    If given a department name, is there an easy way to filter all the workorder that has that department?
    workorder holds the category name, and category holds the department name. I am not sure how to link these two tables together to do this search.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    You don't know how to write a JOIN? Can't you just join the Category columns of both tables?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    May 2007
    Posts
    24
    At first I though a join wasn't what I was looking for, but figured it out. Was quite easy

Posting Permissions

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