I've got a problem with writing a SELECT statement and I'm hoping some guru here can help. I bet the problem has to do with a normalization problem, but we'll see.<BR ...

SIR,<BR>I WOULD LIKE TO DESCRIBE MY PROBLEM WITH AN EXAPLE. I HAVE A TABLE say table1 IN MS-ACCESS WITH DATA<BR>-----<BR>SUBJECT_CODE SUBJECT_NAME<BR>-----<BR>PHY ...