[thelist] SQL Help Please
Matt Warden
mwarden at gmail.com
Fri Jan 13 15:02:40 CST 2006
-----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-----
More information about the thelist
mailing list