topic Join using SQVI in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/join-using-sqvi/m-p/2265063#M491425 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am using SQVI to create a query on LTAP and USER_ADDR.When I join these two tables the default join condition is between LTAP-MAKTX and USER_ADDR-NAME_FIRST. I am able to delete this join condition but not able to create a join condition between LTAP-QNAME and USER_ADD-BNAME.How do i create my own join condition.</P><P>Thanks in Advance</P><P>Sandeep</P></BODY></HTML> Tue, 22 May 2007 15:14:03 GMT Former Member 2007-05-22T15:14:03Z Join using SQVI https://community.sap.com/t5/application-development-and-automation-discussions/join-using-sqvi/m-p/2265063#M491425 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am using SQVI to create a query on LTAP and USER_ADDR.When I join these two tables the default join condition is between LTAP-MAKTX and USER_ADDR-NAME_FIRST. I am able to delete this join condition but not able to create a join condition between LTAP-QNAME and USER_ADD-BNAME.How do i create my own join condition.</P><P>Thanks in Advance</P><P>Sandeep</P></BODY></HTML> Tue, 22 May 2007 15:14:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/join-using-sqvi/m-p/2265063#M491425 Former Member 2007-05-22T15:14:03Z Re: Join using SQVI https://community.sap.com/t5/application-development-and-automation-discussions/join-using-sqvi/m-p/2265064#M491426 <HTML><HEAD></HEAD><BODY><P>Hi Sandeep,</P><P></P><P>We Can create Our Own Join.You jus Need To point to the Field name of the LTAP-QNAME drag the Line to USER_ADD-BNAME.</P><P></P><P>Hope this Helps.</P><P></P><P>Regards,</P><P>Mithun</P></BODY></HTML> Wed, 23 May 2007 13:50:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/join-using-sqvi/m-p/2265064#M491426 mithun_shetty4 2007-05-23T13:50:12Z