Search results for query: *

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...

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.

I was not very clear in the previous post. B.colx is not among the joined fields, that is what I was trying to say.

Thanks Terry, seems to work, though I don't understand the logic! b.colx was not bringing in the null values, so I would've thought we should condition for null on the fields that don't come in instead of b.colx.

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...

John, It works using tlbroadbent's first suggestion. Thanks to everyone who responded.

SELECT LIB900BOFA.INGLPF.INTTYP, LIB900BOFA.INGLPF.DPTPCT, LIB900BOFA.INGLPF.OPNAME, LIB900BOFA.INGLPF.CATDES, LIB900BOFA.INGLPF.IPFLAG, MST900BOFA.GLMTPF.FSSEQ, LIB900BOFA.INDSPF.ID, LIB900BOFA.INGLPF.ACTNM2, LIB900BOFA.INDSPF.DESCRIPTION1, LIB900BOFA.INDSPF.DESCRIPTION2...

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...