Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    Answered: Help with join statement

    I created a trigger behind a table that works perfectly

    trouble is i just found out more than one field is required for the criteria

    presently the join looks like this

    JOIN inserted as ins ON tar.OrderNo = ins.OrderNo

    can I just add on the other fields like this?

    JOIN inserted as ins ON tar.OrderNo = ins.OrderNo, tar.appid = ins.appid, tar.status = ins.status;

    Thank you in advance
    Dale Houston, TX

  2. Best Answer
    Posted by Pat Phelan

    "No, but you can do that join using AND instead of comma in the list.

    -PatP"


  3. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    No, but you can do that join using AND instead of comma in the list.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #3
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    Thanks Pat - synapse misfiring totally - If I opened the immediate window in VBA I would have typed it with the "and" LOl

    thank you
    Dale Houston, TX

Posting Permissions

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