| Author |
 Topic  |
|
|
ATG
Starting Member
USA
35 Posts |
 Posted - 01/24/2013 : 17:57:27
|
I need to join two tables. One is just a static table that contains a list of values. The second table varies in content.
Table 1 has values:
010000
011000
012000
013000
.
.
.
991000
Table 2 would be something like:
012000, $150
013000, $465
022000, $45
The problem I'm getting is that it only returns rows where Table 2 has a value.
I need it to show like
010000, null
011000, null
012000, $150
...
012100, null
013000, $465
etc...
Whats the best way to go about doing this? I thought a left join would do it but it doesn't seem to be right.
Here is what I have so far....
select *
from Table1
LEFT JOIN Table2 on Table1.Company=Table2.Company and Table1.WBSCode=Table2.WBSCode
where (Table2.Company=1 or Table2.Company is null) and (Table2.JobNum='132311.' or Table2.JobNum is null) or (Table2.Order='35' or Table2.Order is null)
|
|
|
jimf
Flowing Fount of Yak Knowledge
USA
2868 Posts |
Posted - 01/24/2013 : 18:24:41
|
You're correct in doing a left join, but it looks like you where clause is turning you left join into an inner join. Try something like this
select *
from Table1
LEFT JOIN Table2 on Table1.Company=Table2.Company and Table1.WBSCode=Table2.WBSCode
and (Table2.Company=1 or Table2.JobNum='132311.' Table2.Order='35')
Jim
Everyday I learn something that somebody else already knew |
 |
|
|
ATG
Starting Member
USA
35 Posts |
Posted - 01/24/2013 : 18:46:14
|
I had a feeling that was happening but didn't think to solve it via the join, but rather the where clause.
The code below did it...
select *
from Table1
LEFT JOIN Table2 on Table1.Company=Table2.Company and Table1.WBSCode=Table2.WBSCode
and ((Table2.Company=1 or Table2.Company is null) and (Table2.JobNum='132311.' or Table2.JobNum is null) and (Table2.Order='35' or Table2.Order is null))
Once again, thanks alot! |
|
|
| |
Topic |
|
Left join not working??
