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 bkrike 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: *

  • Users: knacath
  • Content: Threads
  • Order by date
  1. knacath

    Beginner XML Project

    Hi folks, I'm a beginner to this technology and need some basic information. I'm a programmer needing to do an xml project for an undergraduate class. This class does not cover xml but the one next semester does. So, this project will be a lead-in for the next class. The instructor has given us...
    • knacath
    • Thread
    • Replies: 0
    • Forum: XML
  2. knacath

    Joining to a different field if one is blank

    Hi folks, I've run into an interesting problem. I've 2 tables, Table1 & Table2. Table1.A needs a join to Table2.C. However, if Table1.A is blank (empty string, not null), it is Table1.B that needs to go out to Table2.C I'm using DB2/AS400. Any ideas?? Thanks.
  3. knacath

    Outer joins problem

    Hi, I have two tables left outer joined. Without a whereclause I can see my null rows from the right table. When I insert a where clause on a field in the right table, the outer join is negated, and the output appears as if the tables were equijoined. This is for AS/400. Is this normal, and is...
  4. knacath

    Whereclause question

    Hi folks, I want to exclude rows if two columns in the whereclause have a specific value. For eg., I want to exclude rows with Column A =1 and column B = 2. However, I want this to happen only when both of them have these values, not just one, so a simple where Column A <> 1 and column B <> 2...

Part and Inventory Search

Back
Top