Issue with Database View, Not able to fetch records

[David Cross]

i have 2 tables to join

Table 1 : asmt_assessment_instance

Table 2 : asmt_assessment_instance_question

i am trying to join both the tables but unable to do so, please help me here. below is my condition to join

My Condition which is added in DataBase view, what did i do wrong here. please help 

[Brad Bowman · Accepted solution]

Hi David,

You should always have different Order numbers for each table in a join, with the Where clause being on the table with the higher Order.  Since the instance field on the question table is a reference it's storing a sys_id, so your Where clause on the second table should be

 inst_sys_id = que_instance

[David Cross]

Hey Thank you @Brad ..