Hey all. Can i use the tail function in a join statement. If so How?
I am having this issue cas the pin# in Student table is 0234 while in yearReport it is 234. So if it possible to compare the tail in the code below would help me alot.
Select Student.studentID, yearReport.* INTO studentAll
From yearReport Left Join student ON yearReport.pin = student.pin1;
I am having this issue cas the pin# in Student table is 0234 while in yearReport it is 234. So if it possible to compare the tail in the code below would help me alot.
Select Student.studentID, yearReport.* INTO studentAll
From yearReport Left Join student ON yearReport.pin = student.pin1;