I am working in Developer Studio and when trying to join Table A to Table B on more than one field (for example ID and DATE are in both tables), after i run my join and go back in, i see that Dev Studio adds the joined table in again and has a join seperately (one to ID and another join to the same table on DATE). If this worked correctly, there would be no issue, but it doesn't recognize that both fields HAVE to match in order to pull in the data. I'm not sure what its doing but it's not working properly. I read that i may need to create a concatenated field of the two fields i am looking to join properly and i've tried this and it works but I'd like to know if there is something i was doing wrong in the first place. I had the join set as a LEFT OUTER and on multiple instances. I have learned recently that there are two different ways to do joins (using the PASS settings with single or multiple instances???) but i am not very comfortable with it and have so far opted to use LEFT OUTER or INNER joins to accomplish what i'm trying to do. Is there anything wrong with that as well? Any info would be appreciated.

Thank you,

Andrea

This message has been edited. Last edited by: Kerry,

Normally, I just type in the codes directly rather than using developer studio to generate the codes for me.

You're probably getting this code after using developer studio:

JOIN ID IN TABLE_A TO ID TABLE_B AS J0 END
JOIN DATE IN TABLE_A TO DATE IN TABLE_B AS J1 END

What you want to achieve is:
JOIN ID AND DATE IN TABLE_A TO ID AND DATE TO TABLE_B AS J0 END

I hope this helps.

what Shirley has provided will work with non-FOCUS DBs, but you can only join to one field in a FOCUS DB. You can work around this by adding a WHERE statement on the second field or by concatenating the 2 fields together (in both files) and joining on that field.

I see - thank you both!