Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Jago11

    When to use 1=1 logic

    Essentially, if there is no ccy match, take the df value relative to the latest deal num.
  2. Jago11

    When to use 1=1 logic

    I haven't explained it very well. This is what we're trying to do https://files.engineering.com/getfile.aspx?folder=81eeeb4b-4b2f-4cec-91e1-1302f535817f&file=Untitled_picture.png
  3. Jago11

    When to use 1=1 logic

    Hi, It's been quite some time since I was in amongst code, and am wondering how to use 1=1 logic in order to relax a join condition. Can you advise if this syntax is correct? ) ON table1.id_number = table2.id_number AND (table3.currency = table2.currency OR 1=1) which is intending to take a...

Part and Inventory Search

Back
Top