I have three tables (iwc, sensors and valves) and I want to get the number of different suppliers from these three tables. If I had just one table, I know I'd do this:
select distinct(column) from table"
, but how would I go about doing this with three? Is it even possible?
(btw, I'm using an access database)
Thanks in advance (although I'll probably say thanks again at the end )