# Relation join not correct in view:browse for a table alias. Conversion from Clarion 6 to 9

**URL:** <https://clarionhub.com/t/relation-join-not-correct-in-view-browse-for-a-table-alias-conversion-from-clarion-6-to-9/9187>\
**Category:** questions\
**Tags:** dictionary\
**Created:** [June 23, 2026, 2:47pm UTC](https://clarionhub.com/t/relation-join-not-correct-in-view-browse-for-a-table-alias-conversion-from-clarion-6-to-9/9187 "2026-06-23T14:47:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mjkuhn](https://clarionhub.com/letter_avatar_proxy/v4/letter/m/a183cd/32.png) [@mjkuhn](https://clarionhub.com/u/mjkuhn)\
**Post date:** [June 23, 2026, 2:47pm UTC](https://clarionhub.com/t/relation-join-not-correct-in-view-browse-for-a-table-alias-conversion-from-clarion-6-to-9/9187/1 "2026-06-23T14:47:54Z")

</div>

This was just discovered in Clarion9 app that was converted from Clarion 6. I just opened the Clarion6 dictionary and the app; the relation join is correct and the view:browse is correct

I then checked the Clarion9 dict and app. Dictionary unchanged the app however is not using the correct relation data.

Still trying different things to try to get something to change, No Luck.

Employees has an alias EmpCR, The relations are correct Transactions:CREmpid ← EmpCR.SysID. In a view:browse for Transactions this a partial list, showing EMPCr:Pkey joined to Transactions:EmpID. Should be joined to Transactions:CREmpId

```
                   PROJECT(Transactions:CREmpID)
                   PROJECT(Transactions:EmpID)
                   PROJECT(Transactions:SysID)
                   PROJECT(Transactions:CRTime)
                   PROJECT(Transactions:TypeID)

                   JOIN(EMPCr:PKey,Transactions:EmpID)
                     PROJECT(EMPCr:FullName)
                     PROJECT(EMPCr:CREmpID)
                     PROJECT(EMPCr:SysID)
                   END

                   JOIN(Employees:PKey,Transactions:EmpID)
                     PROJECT(Employees:FullName)
                     PROJECT(Employees:SysID)
                   END

```

---

<div class="post-metadata">

**Author:** ![mjkuhn](https://clarionhub.com/letter_avatar_proxy/v4/letter/m/a183cd/32.png) [@mjkuhn](https://clarionhub.com/u/mjkuhn)\
**Post date:** [June 23, 2026, 2:58pm UTC](https://clarionhub.com/t/relation-join-not-correct-in-view-browse-for-a-table-alias-conversion-from-clarion-6-to-9/9187/2 "2026-06-23T14:58:58Z")

</div>

OK. We can forget this. I did not deleted it because it has a solution. The last thing I just tried was to delete the Relationship in the dictionary and save it. Then reopen and add the relationship back in. Rebuilt the app and the view:browse now shows the correct join.

This now means I need to review all the other Alias relationships for additional anomalies.