You were so very close to getting what you wanted!
What is causing the problem is the comma (,) in your FROM clause. MySQL
permits two methods of declaring an INNER JOIN. The first is by using the
keyphrase "INNER JOIN" the second is with a comma in your table list. Here
is how to rephrase your
Hello List,
I have a problem that I am looking your help for. Would greatly appreciate it. Here is
what I am trying to do:
create table C (cId tinyint(4), cName varchar(10));
insert into C values (1,'Cat01'), (2,'Cat02'), (3,'Cat03'), (4,'Cat04');
create table SC (scId tinyint(4), cId tinyint(4
