Hi folks,
I've a sql query problem I was wondering if you all had a quick and
dirty solution for. I've a query:
Select code, value from table_a where date in
(2004) and a_code in ('1000','2000') and b_code in ('01000','02000')
This returns a table that looks like:
A_CODE B_CODE VALUE
------ ------ -----
1000 01000 $500
1000 02000 $750
What I'd like to see is:
A_CODE B_CODE VALUE
------ ------ -----
1000 01000 $500
1000 02000 $750
2000 01000 $0
2000 02000 $0
Any suggestions on how to rewrite my query so the results show A_CODE
2000 with a VALUE of 0 or null?
Thank much in advance!
Marc