MySQL Forums
Forum List  »  Newbie

Re: Newbie question
Posted by: Peter Brawley
Date: October 16, 2014 04:40PM

Because no account row has account_type_name='saving' and account_type_name='checking'. It seems you want ...

select client_id
FROM accounts
WHERE account_type_name = 'checking' OR account_type_name = 'saving';

Options: ReplyQuote


Subject
Written By
Posted
October 16, 2014 03:10PM
Re: Newbie question
October 16, 2014 04:40PM
October 16, 2014 04:48PM
October 17, 2014 08:05AM
October 16, 2014 04:43PM
October 16, 2014 04:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.