We have two tables, the master table has a primary key i.e. Multiple of two fields. Now I want to create a view that consist of fields from both Master and child tables. But while designing a view the join condition have no option for multiple field.

I am looking for a solution.