Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

how can i select the player with the most goals of each team using subquery?

Danicrod's profile image Danicrod posted 3 weeks ago in General Permalink

This is the structure:

CREATE TABLE Jugadores ( codJ INT(5), nombreJ VARCHAR(55), goles INT(10),

PRIMARY KEY(codJ)

);

CREATE TABLE Equipos ( codEquipo INT(5), codJ INT(5), nombreE VARCHAR(55),

PRIMARY KEY (codEquipo),
FOREIGN KEY (codJ) REFERENCES Jugadores (codJ)

);

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.