[thelist] one-to-many join problem
Matt Warden
mwarden at gmail.com
Sat Jan 14 19:21:54 CST 2006
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Brian Cummiskey wrote:
> I think what i want to group on is the confirmation code though... no?
Sure. I didn't only because it isn't in the selected fields list.
>>your expanded recordset would look like this:
>>
>>joe guy 1 1 0
>>joe guy 1 0 0
>>
>>and grouped you will have:
>>
>>joe guy 2 1 0
>>
>>which I think is what you want.
>>
>>
>
>
> let me play a little more with this.
> My code is very similar to what you have, only i'm joining with an
> explicit left outer join.
Which is what you want to do if it's possible that there are customers
with no Phones record(s).
> In my table, like you have above, I have a field called dsl, and
> the text value of the plan is stored there if ordered.
That will work just as well. Just use the plan names as the test values
in the case statements.
- --
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
iD8DBQFDyZ4FrI3LObhzHRMRAiYvAJ4+3GX/pFNZgBjmj4zxJAOOZcdjrwCgjxV+
aLTZxZp5L1bHNda+Kq1Q9hM=
=vaq3
-----END PGP SIGNATURE-----
More information about the thelist
mailing list