AC5FF
Registered User.
- Local time
- Today, 10:08
- Joined
- Apr 6, 2004
- Messages
- 552
I'm working with some databases that were not fully thought out and I need to join some fields where the data might not be the same.
I could use another query or two and make it work - but I'm trying to avoid doing that if at all possible.
How would I join the two tables if my customer table shows an account number of "002-123" and my product table shows the account number as "W02-123"
Thx
I could use another query or two and make it work - but I'm trying to avoid doing that if at all possible.
How would I join the two tables if my customer table shows an account number of "002-123" and my product table shows the account number as "W02-123"
Thx