1. Learn
  2. /
  3. Courses
  4. /
  5. SQL Tutorial for Marketers

Exercise

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?

Instructions

50 XP

Possible answers