I know the answer to that question but im not going to tell you. Simply because im bitter and mean.Niksta123 said:Can some one help me out on:
How to construct an SQL command from the HSC IPT 2006 paper Qu 21 (A)
thanks
Almost right, you don't need single quotes around the table countries, since it's an internal entity of the database.Niksta123 said:SELECT CountryName
FROM 'Countries'
WHERE Continent = 'South America' AND Language = 'Spanish'
SELECT CountryName FROM Countries WHERE Continent = 'South America' AND Language = 'Spanish';