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