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 to
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 tr
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 o
