This is the query:
list ALL designers giving names and numbers, all modules they design(just module name), and the names of all the applications in which a module which they supply is used. the list should be grouped by designer name and sorted by application whithin each group.
This is my attempt, but i find that all designer names do not show, and the query is not grouped at all. can some one please help me to fix this query?
heres my attempt
SELECT DName, A.Designerid, modulename, AppsName
FROM Designer A, MODULE B, APPLICATIONMODULE C, APPLICATION D
WHERE A.Designerid = B.Designerids
AND C.ModuleNo= B.ModuleNo
AND C.ApplicationNo = D.ApplicationNo
ORDER BY APPSNAME;