Wie drucken Sie Name und Note in FASTREPORT?

[Alg2009]

Hello,

Zitat:

It's an easy mistake that I have left as it is...from me. You have to find it out yourself. Write the error message here.

The error was in the connection settings

I almost visit GitHub website and i didn't know it is a repository thank you for all the information that will help me in the future


There is only one last question
You said

Zitat von haentschman:

- Never use DB tables. Better use Querys.

That's means i link all the tables together with JOIN(inner,Left or Right) the question is If, for example, we add another table to the database let it be 'Group' -->the relation between Student and Group is one to many(Each student has one group, and each group has more than one student)

We write two queries the first to show the students and their grades And the other to show the students and their group or only one query ?

because if we write one query the result it will be wrong

Code:

SELECT E.ID, E.NOM, E.PRENOM, GroupName,LE.NOMLECON, LE.NOTE FROM ETUDIANT E
JOIN ETUDLECON LO ON E.ID = LO.ID
JOIN LECON LE ON LO.LECONID = LE.LECONID
JOIN Group G ON G.GroupID = E.GroupID