• From: Gorontalo
  • Registered: 04-12-2008
  • Posts: 1

Topic: numpang nanya gan! cara menampilkan data multiple pada mysql

ini snip codenya:

    SELECT 
            tbk01_get.no_form,tdpd01_task.task,tdpd01_task.num_inaguration
            ,tdpd01_task.tgl_pengukuhan,tbk01_send.name,tbk01_send.address,tdpd01.task_retribution,
            tdpd01_a.jobs,tdpd01_b.corps, tdpd01_b.works,
            tdpd01_b.address_strees as addressb,tdpd01_b.home_number as nob
            ,tskf.needed, tskf.no_reg, $date_skf_fmt as date_skf_fmt
            FROM tbk01_get 
    INNER JOIN tdpd01 ON tbk01_get.no_form = tdpd01.no_form    
    LEFT OUTER JOIN tdpd01_task ON tbk01_get.no_form = tdpd01_task.no_form  
    INNER JOIN tbk01_send ON tbk01_get.no_form = tbk01_send.no_form    
    LEFT JOIN tdpd01_a ON  tbk01_get.no_form = tdpd01_a.no_form
    LEFT JOIN tdpd01_b ON  tbk01_get.no_form = tdpd01_b.no_form
    LEFT JOIN tskf ON tdpd01_task.task=tskf.task
    WHERE tdpd01_task.task =?

bagaimana cara menampilkan table multiple pada mysql, saya mau menampilkan beberapa data seperti: tskf.no_reg, tdpd01_b.works, date_skf_fmt? atas bantuannya diucapkan terima kasih smile

Open Brain With OPEN SOURCE

anshell's Website