Topic: SQLQuery for select in the Grid
Hello, I do not speak much English, so I will try to formulate my question in the best possible way.
How can I make several selections in the "Table Grid" object and print them through a SLQQuery?
I print one with this code
SELECT
student.firstname,
student.lastname,
student.photo,
student.direcpart,
student.datoscadete,
student.parentname,
student.material,
student.yearstart,
student.yearend,
student.ujc,
student.cdr,
student.pcc,
student.fmc,
groupname.groupname,
sex.sexname,
prohod.proname,
munihod.muniname,
socialstatus.socialstatus,
university.nuniversity,
specname.specname,
student.surname,
student.phone,
student.ci,
student.id
FROM student
LEFT OUTER JOIN groupname ON student.id_groupname = groupname.id
LEFT OUTER JOIN sex ON student.id_sex = sex.id
LEFT OUTER JOIN prohod ON student.id_prohod = prohod.id
LEFT OUTER JOIN munihod ON student.id_munihod = munihod.id
LEFT OUTER JOIN university ON student.id_university = universidad.id
LEFT OUTER JOIN specname ON student.id_specname = specname.id
LEFT OUTER JOIN socialstatus ON student.id_socialstatus = socialstatus.id
WHERE student.id = $ id
if I want to print all I remove the last line.
But, how a selection?