Join Types

[tbpowers]

When creating relationships between tables, in the DataSet Designer, is there a way to specify the join type (Inner, Left Outer, etc...)?

 

[cjard]

A relationship isnt a join per se.. or you could think of it as a left join, with the parent on the left.. A parent can have no children but a child cannot lack a parent

 

[jmcilhinney]

A relation is not a join. A relation can be one-to-one or one-to-many. A join generally uses a relation, either explicit or implicit, to retrieve data from two tables. An inner join will get only those parents that have children while an outer join will get all parents regardless of whether they have children or not. You could execute two queries on the same pair of tables, one using an inner join and one using an outer join, but that doesn't mean that the relation between the tables changes.

 

[tbpowers]

We are still trying to cascade comboboxes. The tables are related, however it is not a foreign key relation. We have yet to get it to work by creating the relationships in the dataset. We are at loss on getting this to work!

 

[jmcilhinney]

Maybe you could provide a full and clear description. We can't help if we have to guess the details.

 

[tbpowers]

Cascading Comboboxes

We have three tables with lookup information for the comboboxes. These are linked using a sub id. So for instance, the sub id in the first table is linked to the category id in the second table. Respecitvely, the sub id in the second table is linked to the category id in the third table. As you can see, from our example data below, there may be the same value and label assigned to more than one category, so these are not foreign key related. We setup a "Relation Only" relationship in the dataset, but it is not working. We appreciate any help you can provide and just let us know if more information is needed to understand our issue.
[TABLE="width: 500"]
[TR]
[TD]CATEGORY_ID[/TD]
[TD]SUB_ID[/TD]
[TD]VALUE[/TD]
[TD]LABEL[/TD]
[/TR]
[TR]
[TD]PCAT[/TD]
[TD]COND[/TD]
[TD]CONDENSER[/TD]
[TD]Condenser[/TD]
[/TR]
[TR]
[TD]PCAT[/TD]
[TD]CONT[/TD]
[TD]CONTROLLER[/TD]
[TD]Controller[/TD]
[/TR]
[TR]
[TD]PCAT[/TD]
[TD]EVAP[/TD]
[TD]EVAPORATOR[/TD]
[TD]Evaporator[/TD]
[/TR]
[TR]
[TD]PCAT[/TD]
[TD]SENS[/TD]
[TD]SENSOR[/TD]
[TD]Sensor[/TD]
[/TR]
[/TABLE]

[TABLE="width: 500"]
[TR]
[TD]CATEGORY_ID[/TD]
[TD]SUB_ID[/TD]
[TD]VALUE[/TD]
[TD]LABEL[/TD]
[/TR]
[TR]
[TD]COND[/TD]
[TD]COMP[/TD]
[TD]COMPOSITE[/TD]
[TD]Composites[/TD]
[/TR]
[TR]
[TD]COND[/TD]
[TD]FASN[/TD]
[TD]FASTNER[/TD]
[TD]Fastner[/TD]
[/TR]
[TR]
[TD]CONT[/TD]
[TD]ELCO[/TD]
[TD]ELECTRIC_CONTROL[/TD]
[TD]Electric Control[/TD]
[/TR]
[TR]
[TD]CONT[/TD]
[TD]FASN[/TD]
[TD]FASTNER[/TD]
[TD]Fastner[/TD]
[/TR]
[TR]
[TD]EVAP[/TD]
[TD]COMP[/TD]
[TD]COMPOSITE[/TD]
[TD]Composites[/TD]
[/TR]
[TR]
[TD]EVAP[/TD]
[TD]DTBE[/TD]
[TD]DRAIN_TUBE[/TD]
[TD]Drain Tube[/TD]
[/TR]
[TR]
[TD]SENS[/TD]
[TD]ELCT[/TD]
[TD]ELECTRIC_CONNECTOR[/TD]
[TD]Electric Connector[/TD]
[/TR]
[TR]
[TD]SENS[/TD]
[TD]SEFA[/TD]
[TD]SENSOR_FAILURE[/TD]
[TD]Sensor Failure[/TD]
[/TR]
[/TABLE]

[TABLE="width: 500"]
[TR]
[TD]CATEGORY_ID[/TD]
[TD]SUB_ID[/TD]
[TD]VALUE[/TD]
[TD]LABEL[/TD]
[/TR]
[TR]
[TD]COMP[/TD]
[TD]BRKN[/TD]
[TD]BROKEN[/TD]
[TD]Broken[/TD]
[/TR]
[TR]
[TD]COMP[/TD]
[TD]CRKD[/TD]
[TD]CRACKED[/TD]
[TD]Cracked[/TD]
[/TR]
[TR]
[TD]FASN[/TD]
[TD]BRKN[/TD]
[TD]BROKEN[/TD]
[TD]Broken[/TD]
[/TR]
[TR]
[TD]FASN[/TD]
[TD]MISG[/TD]
[TD]MISSING[/TD]
[TD]Missing[/TD]
[/TR]
[TR]
[TD]ELCO[/TD]
[TD]CNCT[/TD]
[TD]CONNECTOR[/TD]
[TD]Connector[/TD]
[/TR]
[TR]
[TD]ELCO[/TD]
[TD]CPFL[/TD]
[TD]COMPONENT_FAIL[/TD]
[TD]Component Fail[/TD]
[/TR]
[TR]
[TD]ELCT[/TD]
[TD]CNCT[/TD]
[TD]CONNECTOR[/TD]
[TD]Connector[/TD]
[/TR]
[TR]
[TD]ELCT[/TD]
[TD]SFTW[/TD]
[TD]SOFTWARE[/TD]
[TD]Software[/TD]
[/TR]
[/TABLE]