Search
Search titles only
By:
Search titles only
By:
Log in
Register
Search
Search titles only
By:
Search titles only
By:
Menu
Install the app
Install
Forums
New posts
All threads
Latest threads
New posts
Trending threads
Trending
Search forums
What's new
New posts
New ads
New profile posts
Latest activity
Free Ads
Latest reviews
Search ads
Members
Current visitors
New profile posts
Search profile posts
Contact us
Latest ads
එක පැකේජ් එකයි මාසෙටම Unlimited Internet. තාමත් DATA CARD දාන්න සල්ලි වියදම් කරනවද? අඩුම මිලට අපෙන්.
sayuru bandara
Updated:
Tuesday at 12:30 PM
Ad icon
ඉන්ටර්නෙට් එකෙන් හරියටම සල්ලි හොයන්න සහ Success වෙන්න කැමතිද? 🚀 (E-Money & Success Stories)
siri sumana
Updated:
Saturday at 11:44 PM
Gemini AI PRO 18 months Offer
Hawaka
Updated:
May 27, 2026
Ad icon
koko account
DasunEranga
Updated:
May 27, 2026
Ad icon
koko account
DasunEranga
Updated:
May 27, 2026
Electronics
Vehicles
Property
Search
Reply to thread
Forums
General
ElaKiri Talk!
SQL Query Help
Get the App
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="lilman" data-source="post: 26933858" data-attributes="member: 200726"><p><span style="font-size: 22px"><strong>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=":)" /></strong></span></p><p></p><p></p><p></p><p><strong>Need this colums with 0 duplicates</strong></p><p></p><p><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></p><p></p><p></p><p><strong>My SQL quary </strong></p><p><strong></strong></p><p><strong>[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]</strong></p><p><strong></strong></p><p><strong></strong></p><p><strong></strong></p><p><strong></strong></p><p><strong></strong></p><p><strong></strong></p><p><strong></strong></p><p><strong>Tables</strong></p><p></p><p><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></p><p><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></p><p><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></p><p><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></p><p><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></p></blockquote><p></p>
[QUOTE="lilman, post: 26933858, member: 200726"] [SIZE=6][B]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 :)[/B][/SIZE] [B]Need this colums with 0 duplicates[/B] [url=https://ibb.co/nBHQTwd][img]https://i.ibb.co/0KgYkn4/outpu.png[/img][/url] [B]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[/B] [url=https://imgbb.com/][img]https://i.ibb.co/yF2mXWP/clients.png[/img][/url] [url=https://ibb.co/W205rt1][img]https://i.ibb.co/qrCjH5w/comp-jobs.png[/img][/url] [url=https://imgbb.com/][img]https://i.ibb.co/jwr3D55/devices.png[/img][/url] [url=https://ibb.co/4sLQj5K][img]https://i.ibb.co/tZ6dbWQ/jobs.png[/img][/url] [url=https://imgbb.com/][img]https://i.ibb.co/DkGPtJP/job-types.png[/img][/url] [/QUOTE]
Insert quotes…
Verification
Winadiyakata thappara keeyak tibeda?
Post reply
Top
Bottom
Gemini AI PRO 18 months Offer
