Any one Please, I have created the data base view for two tables

[mastan babu ko1]

I have created the DataBase view between sccm application catlog item and pc catalog item Tables. But I don't know how to create the where clause to get the relationship between tables , Could someone can help me please?

[Ankur Bawiskar]

@mastan babu ko1 

is there any field which holds common information?

based on that you can define your where clause

[mastan babu ko1]

Yes there is a one comman field which is type flage field(true/false) (Bot Software)