Mysql 4.x
I have a one to many case, key is `id`, in this case, I have tables users
and transactions.
A user can have 1 to x transactions, each transaction has a status to it as
well. I want to be able to get users where there is a transaction status of
'wells', however, there can be more than
Put your select here to us. With it we can help you better.
Scott Haneda [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
Mysql 4.x
I have a one to many case, key is `id`, in this case, I have tables users
and transactions.
A user can have 1 to x transactions, each transaction
Scott, is it as easy as SELECT DISTINCT?
SELECT DISTINCT u.username
FROM user u, transactions t
WHERE u.userid = t.userid
AND t.status = 'wells'
Dan
Scott Haneda wrote:
Mysql 4.x
I have a one to many case, key is `id`, in this case, I have tables users
and transactions.
A user can have 1