SELECT TR.IDNO, TR.Name, TR.FATHER_HUSBAND_NAME, TR.ADDRESS,TR.GENDER,TR.MOBILE_PHONE,TR.PLACED,TR.dob,
TI.INDUSTRYNAME,TR.TR_INDUSTRYNAME,TR.ADDCORRESPONDENCE,TI.INO,TP.INO AS P_INO,TP.dop,
TR.CTC,TR.MONTH1,TR.MONTH2,TR.CHANGE_MONTH2,TR.MONTH3,TR.CHANGE_MONTH3,TR.MONTH4,TR.CHANGE_MONTH4,TR.MONTH5,TR.CHANGE_MONTH5,TR.MONTH6,TR.CHANGE_MONTH6,TR.MONTH7,TR.CHANGE_MONTH7,TR.MONTH8,TR.CHANGE_MONTH8,TR.MONTH9,TR.CHANGE_MONTH9,TR.MONTH10,TR.CHANGE_MONTH10,TR.MONTH11,TR.CHANGE_MONTH11,TR.MONTH12,TR.CHANGE_MONTH12,TR.REMARKS
FROM batch TB, trainee AS TR, training_center AS TC,indusmaster TI, placement TP
WHERE TC.TC_Code_no = TB.TC_Code_no
AND TB.TC_code_no = TR.TC_Code_no
AND TB.batch_no = TR.batch_no
AND TR.IDNO = TP.IDNO
AND TP.ino = TI.ino
AND TC.TC_code_no =’" . $tccode . "’
AND TB.batch_no =’" . $batch . "’
union all
(SELECT TR.IDNO, TR.Name, TR.FATHER_HUSBAND_NAME, TR.ADDRESS, TR.GENDER,TR.MOBILE_PHONE,TR.PLACED,TR.dob,’’,’’,TR.ADDCORRESPONDENCE,’’,’’,’’,
TR.CTC,TR.MONTH1,TR.MONTH2,TR.CHANGE_MONTH2,TR.MONTH3,TR.CHANGE_MONTH3,TR.MONTH4,TR.CHANGE_MONTH4,TR.MONTH5,TR.CHANGE_MONTH5,TR.MONTH6,TR.CHANGE_MONTH6,TR.MONTH7,TR.CHANGE_MONTH7,TR.MONTH8,TR.CHANGE_MONTH8,TR.MONTH9,TR.CHANGE_MONTH9,TR.MONTH10,TR.CHANGE_MONTH10,TR.MONTH11,TR.CHANGE_MONTH11,TR.MONTH12,TR.CHANGE_MONTH12,TR.REMARKS
FROM batch TB, trainee AS TR, training_center AS TC, placement TP,indusmaster TI
WHERE TC.TC_Code_no = TB.TC_Code_no
AND TB.TC_code_no = TR.TC_Code_no
AND TB.batch_no = TR.batch_no
AND TR.TRAINING LIKE ‘%Completed%’
AND TR.PLACED = ‘N’
AND TC.TC_code_no =’" . $tccode . "’
AND TB.batch_no =’" . $batch . “’)”
I was working on drupal earlier…not i want to work on yii…so i want to use the same query but through model and controller…please tell me how to write this query using model and controller and i dont have any foreign key also in my table.