Reply to thread

Message: <blockquote data-quote="lilman" data-source="post: 26933858" data-attributes="member: 200726">machanla mata me pahala tiyana output eka ganna quary eka liyaganna help ekak denna puluwanda ? mama liyapu eken rows duplicate wenawa.mata one Jobs table eke rows tika penwanna liyaganna <img src="/styles/default/xenforo/smilies/default/happy.gif"  class="smilie" loading="lazy" alt=":)" title="Happy    :)" data-shortname=":)" />Need this colums with 0 duplicates<a href="https://ibb.co/nBHQTwd" target="_blank"><img src="https://i.ibb.co/0KgYkn4/outpu.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></a>My SQL quary [CODE=sql]SELECT jobs.job_no, job_types.name AS job_type, clients.name AS client_name, devices.name AS device_name, jobs.model, jobs.serial_no, company_jobs.payment_status, company_jobs.sent_date, company_jobs.received_date, jobs.remarks FROM jobs, job_types, clients, devices, company_jobs WHERE jobs.job_type_id=job_types.id AND jobs.client_id=clients.id AND jobs.device_id=devices.id[/CODE]Tables<a href="https://imgbb.com/" target="_blank"><img src="https://i.ibb.co/yF2mXWP/clients.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></a><a href="https://ibb.co/W205rt1" target="_blank"><img src="https://i.ibb.co/qrCjH5w/comp-jobs.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></a><a href="https://imgbb.com/" target="_blank"><img src="https://i.ibb.co/jwr3D55/devices.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></a><a href="https://ibb.co/4sLQj5K" target="_blank"><img src="https://i.ibb.co/tZ6dbWQ/jobs.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></a><a href="https://imgbb.com/" target="_blank"><img src="https://i.ibb.co/DkGPtJP/job-types.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></a></blockquote>

Verification: Hathara warak wissa keeyada? (Hathara wadi karanna 20)

Top Bottom