Counting records from three tables

[txwylde]

I have three tables I am trying to do a count on to give me a total amount. The problem is that somes of the sales order numbers are unique to the other tables but I want to count the unique records as well as the records that are not in the other tables. Is there an easy way to do this?

Thanks!
Bill

 

[Kozusnik]

You could create a table, append the values, and do a select distinct on the new table. Otherwise, you might need 3 queries.
mark

 

[r937]

you could count the rows in a UNION query

r937.com | rudy.ca