The way that I intended usernames to be stored is in a new table that
holds the attributes for that service. They are called _options
tables. For example, an email service would have a table called
email_options that might hold a username, password, a record of
virtual mail mappings, etc.
The t
Hello,
Would you be able to provide us some more custom queries? Here's the
story.
We are trying to build the interface to search for usernames. Our
usernames are in the form of email addresses. Therefore we just use
the Contact Email field in the customer summary screen as the place to
st
Ah great!
I was studying your database, and I did come to the point where I could see
that I will need to do a
join between customer and user_services. However, I was toying with an INNER
JOIN. Lack of concept
on my part.
Now maybe you can toss it into the web interface >; ) Our marketing
Any of these kinds of queries are possible, though you need to know
about SQL JOIN's to get them done. Here are some examples:
To query a city with a specific service, you need to know the specific
service ID:
SELECT *
FROM customer
LEFT JOIN user_services ON user_services.account_number =
custo
All of our users in the database have a primary contact email address.
I am trying to get a list of all contact email addresses matching their City
and certain added Services.
For example:
I would like a list of email addresses so that I can send an email to all
customers who live in
Kansas Ci
