MySQL Forums
Forum List  »  Newbie

probably an easy for most of you
Posted by: Stéphan Dorion
Date: June 07, 2022 01:36PM

Here my code do not work:

..but I cannot find the solution

Here my table :

nobl

yr. subject winner

1960 Chem Smith
1974 Lit Dorian
1965 Chem Burt
1963 Lit Vold

Show the year, subject, and name of physics winners for 1980 together with the chemistry winners for 1984

SELECT * FROM nobl
WHERE subject =('Chem') AND
yr = 1960 AND
WHERE subject=('Lit') AND
yr = 1974

Not working...

Please help a newbie... :-)

Options: ReplyQuote


Subject
Written By
Posted
probably an easy for most of you
June 07, 2022 01:36PM


Sorry, only registered users may post in this forum.

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.