I'm trying to join two tables and ain't having much luck.
The domains table contains mainy domains and the owners id. Each customer has a unique id in the customers table. ie many domains per customer.
I'm trying to get a list of the domain names and pull some of the records from the customer table. What I've got so far is matching each domain name to every customer.
ie each domain is repeated many times with the details of every customer.
SELECT domains.domain, domains.tag, customers.co FROM domains ,customers WHERE domains.tag=customers.tag
Thoughts? Thanks
The domains table contains mainy domains and the owners id. Each customer has a unique id in the customers table. ie many domains per customer.
I'm trying to get a list of the domain names and pull some of the records from the customer table. What I've got so far is matching each domain name to every customer.
ie each domain is repeated many times with the details of every customer.
SELECT domains.domain, domains.tag, customers.co FROM domains ,customers WHERE domains.tag=customers.tag
Thoughts? Thanks