I have a query where I need to get the data joining two tables. Ex I have table a table b.
I need count(*) of records.
I have my query like this.
select count(*) from table a
left outer join table b on a.aid = b.bid
There are records which may not have a matching id but they should be matched on type.
EX
select count(*) from table a
left outer joinb table b on a.type = b.type
how can i acheive joining table b to include two different columns