Home

Tuesday, March 11, 2014

Under Stand Joins in X++ code

1-Create Two Tables
   i-Student with Fields Id and Name



  ii-Student Assignment with fields AddressCity and Id


2- Create a normal relation in Student Assignment Table in relation node
     StudentAssignment.Id == Student.Id

3- Write a job to find which data will come while using join statement in X++ code for these Tables
   static void Student(Args _args)
{
  Student student;
    StudentAssignment studentAssignment;

    while select student  join studentAssignment where student.Id == StudentAssignment.Id
    {
        info(strfmt("%1",student.Name));
    }

}

OutPut ---->

No comments:

Post a Comment