How can you build a query to compare fields from several tables? In my particular case, I would like to compare prices from 3-5 tables and group them by product. So it would show product A has a price from vendor a, b and c then show product B etc etc.
I think I can only compare two tables at once, then I would have to make a couple other queries and do a union if I understand what I have read correctly. Can anyone offer some insight on this one?
I think I can only compare two tables at once, then I would have to make a couple other queries and do a union if I understand what I have read correctly. Can anyone offer some insight on this one?