DataRelation does not support LEFT JOIN. Is this true?

T

Toni

Hello folks,

we have been trying to use DataRelation that returns LEFT JOIN result
instead of INNER JOIN which seems to be the default behaviour.

Is there a way to do this?


TIA,
Toni
 
V

Val Mazur

Hi,

Do you need to create relation between DataTables where it will be like a
left join? In this case you need to define PK in a left (parent) table and
FK constraint in a right (child) table. Than create relation based on
fields, involved into PK and FK. It will work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataRelation left outer join different database types 4
LEFT JOIN in a Dataset between two tables 3
DataRelation Using WHERE Clause in sql 1
DataRelation / DataSet Question 4
Join two datatables populated from different sources? 7
Left Join query not working in Access 2010 0
SQL: Inner Join Works, Left Join Does Not 1
What is a good strategy for joining data from separate databases 3

Top