> > It returns actual values for artist that my > > query returned as null. Can you tell me why that is? > >The WHERE clause for each of the two selects filters out only those >records that match either "P"erson or "B"and so you're not getting any >extra records with NULLs.
Right. But (he said sheepishly) my tables had actual data in them that should have been returned in the artist field for some performances; instead my query returned nulls in some cases. If I'm understanding you right, they weren't extra records (like one gets, for example, when one doesn't use DISTINCT in some situations). The query failed to find data that it should have found. And it wasn't due to truncation because I tried it with a PADR() wrap and got the same results. Am I making sense? Thanks for all your help. Ken _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
