[thelist] SQL Help Please

[Matt Warden]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> I've got two views. They are identical except that the latter view is a
> subset of the first one that finds specific criteria. For example,
> 
> View A: 2 Customers
> 
> View B: 1 Customer
> 
> 
> Ok. Simply put, I want to join the views and get both those numbers in
> the same record. Sounds easy right? 
> 
>  
> 
> But as you can see here: http://www.lexjet.com/lexjet/rob/two_views.jpg
> something's not right. In the query results, A is View A. I should have
> 2 customers. However in B, B is only supposed to have 1. I'm I joining
> something wrong?

Rob,

I'm having a little trouble understanding the problem. Is there any way
you can give us the data in View A and View B, specifically the
commission_ids?


- --
Matt Warden
Miami University
Oxford, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDyBVwrI3LObhzHRMRAjUXAJ4t/TA4ITbiXvMvlJzzFAexRwETTwCgkuzF
/gkFwa7k9BDk5RrEliRai+s=
=TSVQ
-----END PGP SIGNATURE-----