Do you have a question? Post it now! No Registration Necessary. Now with pictures!
June 25, 2005, 5:54 am
rate this thread
User ----> info about the users UserKey is the key
Gift ----> list of gifts each user has on thier wish list foreign key
Event --->gift giving events for users. foreign key is UserKey
Emails ----> email addresses users have sent a message to about their
wish list. UserKey is the foreign key here too.
The relationship between user and the other 3 tables is a 1 to many. I
have the following query that I need to adjust some.
SELECT u.UserKey, UserID,
Count(distinct g.GiftKey) gifts,
Count(distinct ev.EventKey) events,
Count(distinct e.Email) Emails
FROM User u NATURAL LEFT JOIN Gift g
LEFT JOIN Emails e ON e.Userkey = u.UserKey
LEFT JOIN GiftGivingEvent ev ON ev.UserKey = u.UserKey
GROUP BY UserID
What I really want is only the users where the gifts count is > 3, the
Event count is > 1, the Emails count is > 5 and and only count emails
if e.Verified is = 1
I am pretty sure I have to write code to do the last part with the
emails but is there a way to do the part with the gift and event counts?
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
- » Query help: Get category and number of items in one query
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum