Need to combine data from three tables

Databases
1

I am storing data in three tables that I would like to bring together.

campaigns table: uID, answerDate, campaign, answer
communications table: uID, dateAdded, type, entry
payments table: uID, payDate, type, frequency

What is the best way to do a join on all three so that the output has three columns of:

date
type
entry

This will give me a report with all the details on a given user.

Thanks!

2 
SELECT uID
     , 'campaign' AS source
     , answerDate AS date
     , campaign AS type
     , answer AS entry
  FROM campaigns
UNION ALL
SELECT uID
     , 'communications' AS source
     , dateAdded AS date
     , type
     , entry
  FROM communications
UNION ALL
SELECT uID
     , 'payments' AS source
     , payDate AS date
     , type
     , entry
  FROM payments
ORDER
    BY uID
     , source
3

This is perfect! I tried adding a where uID= 110, to only view the details of one user, but it gave me an error. When combining three tables, what is the right place to add a where clause?

Thanks!

4

in each SELECT, i.e. three times

5

Thanks again Rudy!!