hi i am facing a big problem with a mysql query
i have 3 tables
feat_proj
pId,domain,projName,scope are the fields in this table
value:
1 dom proj_name xxxxx
feat_mod
mId,pId,modName
1 1 mod1
2 1 mod2
feat_sec
sId,mId,PId,secName
1 1 1 sec1
2 1 1 sec2
3 2 1 sec3
4 2 1 sec4
i want a query which will display
proj_name
mod1
sec1
sec2
mod2
sec3
sec4
in a table. Any idea how to achieve this?
thanks for the help,
Suk
