G
Guest
I have two sub queries that are joined together to append to a table. In the
append query i have three joins. Basically the theory behind it is that new
records are appended to a table if any of the learner_code or the course_code
or the year_code are different to records that are already in the table. I
know the query works as I have used it before, but with out a join on
year_code. Since I have added a join on the year_code the query produces
what look like oriental symbols instead of text in one field. If i remove
the join on year code it shows the text. What is this problem about? Is
there something I am missing?
append query i have three joins. Basically the theory behind it is that new
records are appended to a table if any of the learner_code or the course_code
or the year_code are different to records that are already in the table. I
know the query works as I have used it before, but with out a join on
year_code. Since I have added a join on the year_code the query produces
what look like oriental symbols instead of text in one field. If i remove
the join on year code it shows the text. What is this problem about? Is
there something I am missing?