Problem With Left Join in Connector/.Net
Posted by: Danny Weidig
Date: October 27, 2004 04:50PM

I've been working with Connector/.Net successfully until I've tried to perform a left join. When I try to perform a left join, I only get back field data on some of the records that have matching records in the joined table. In the example below, t2.field1 is blank on some records that are returned. However, when I switch to using ODBC, then all records with the t2.field1 are returned successfully with data. Are there any known problem with the Connector that would cause this?

select t2.field1,t1.field1,t1.field2,t1.field3
from table1 t1
LEFT JOIN table2 t2 using (entitycode,linksource,keywordid)
where t1.field1 like 'ent%' and date>='2004-10-26 00:00:00'
and date<='2004-10-27 23:59:59'
group by 2,3,4;


Thanks

Options: ReplyQuote


Subject
Written By
Posted
Problem With Left Join in Connector/.Net
October 27, 2004 04:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.