Funny you should mention that....I ended up dropping Tables 2-6.

Table 7 now has 6 columns that can be joined back to the source table to return only valid transactions. These...

GSquared (12/17/2010)

---

You would need to generate either a real or virtual table of valid combinations, and join to that.

If, for example, "1,2,null" is valid, you need a row in your...

I understand. The big picture often dictates the way some of the minutiae are configured.

Thanks for the follow up anyway.

Dropping out all other details, if I have a dataset containing...

Thanks for the response.

I thought using the separate tables for transaction codes could help me avoid issues with NULL joins. Such is not the case.

Also, why not a table for...

*bump*

I'm new to the forums and still getting my bearings. Is this something that can be asked in the 'Ask SSC' area?

Sample:

Table1 (source data)

Branch,Amount,Code1,Code2,Code3,Code4,Code5

11, $10, 1, C, 1, ...