you need to use my second example. when you do a SQL join, it creates a virtual table. The Result set of the query thinks that all of the fields are from the same table. If you need to keep track of what field is from what original table, rename them to something unique using the AS statement.