<div>
This table does not provide any type of relationship? In other words whether it is a left or right and inner or outer join? You should construct your queries as you needed. This table provides information between tables that one is references by the other. <br />
&nbsp;Let me explain.You have a reference table say categories containing 10 different &nbsp;category. You have an other table say products and and you want each table should belong to one of these categories. So you define a foreign key relation between these tables on the columns regarding to the category data...
</div>


This table does not provide any type of relationship? In other words whether it is a left or right and inner or outer join? You should construct your queries as you needed. This table provides information between tables that one is references by the other.
 Let me explain.You have a reference table say categories containing 10 different  category. You have an other table say products and and you want each table should belong to one of these categories. So you define a foreign key relation between these tables on the columns regarding to the category data...

<div>
Hi. Thanks. So where do I find the type of joins between tables
</div>


Hi. Thanks. So where do I find the type of joins between tables

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I found the Relationships table in Access through the following Select Statement<br />
<br />
SELECT MSysRelationships.*<br />
FROM MSysRelationships<br />
<br />
How do I find the type of relationship? In other words whether it is a left or right and inner or outer join?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/12_w50/692051/Image1.jpg" target="_blank" title="1 (155 KB)"><img alt="1" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2013/12_w50/800_692051/Image1.jpg" /></a>
</div>
</div>


Image1.jpg

Hi

I found the Relationships table in Access through the following Select Statement

SELECT MSysRelationships.*
FROM MSysRelationships

How do I find the type of relationship? In other words whether it is a left or right and inner or outer join?



Access Relationships Where to find the join type

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.