I've got a question about SQL query in MS Access, for example I have the following data:
Table1:
NAME ____ CITY ____ FAV
vahid ______ NY _______ A
vahid ______ NY _______ B
hamed _____ LA _______ A
hamed _____ LA _______ C
Do I able to merge them like this in MS Access 2003...