Hi Tariq ---

This is known as a compound key. Are the fields in the parent that comprise the key reflected in the child table? If so, the following would work, assuming the child table has a completely unique primary key of it's own:

CREATE SQL VIEW myview AS SELECT parent.*,child.* FROM parent, child WHERE
parent.field_1 = child.field_1 AND parent.field_2 = child.field_2.

>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.