Joining Data

Up until now, you have been working with two database tables that give you some data on both your clients as well as your campaigns. Maybe there is some way in which you could join these tables together to get a more complete view on your clients.

Take a look at the following query:

SELECT clientid, age, contact
FROM clients, campaigns
WHERE clients.clientid = campaigns.clientid

What, do you think, would be the result of the following query?

Possible answers

You join the tables clients and campaigns so that you can get to see the age and the way the bank contacted that client.

You just get to see the age of the bank's clients.

Exercise

Joining Data

Instructions

Possible answers