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
ඔයාගෙ Assignment හෝ Thesis එක හරියට හදාගමු
ErMurazor
Updated:
Yesterday at 10:52 PM
Ad icon
BlackWall V2ray servers
hu KANNA
Updated:
Wednesday at 4:58 AM
Peppa Pig Family Plush Toy Set – 5 Characters
anil1961
Updated:
Sep 19, 2026
Ad icon
Express VPN PC - 1 Year Rs. 600.00
Sanathbh
Updated:
Sep 19, 2026
Ad icon
Capcut Pro 7 Days Team Plan - Rs. 3️⃣0️⃣0️⃣
Sanathbh
Updated:
Sep 19, 2026
Electronics
Vehicles
Property
Search
Reply to thread
Forums
General
ElaKiri Help
SQL 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="kalhara96" data-source="post: 20657670" data-attributes="member: 300272"><p><strong>try this machan</strong></p><p></p><p></p><p></p><p><span style="font-size: 12px">මචන් මන් මෙහෙම හිතල උත්තරේ දෙන්නෙ.</span></p><p><span style="font-size: 12px"></span></p><p><span style="font-size: 12px"><strong>**</strong> Invoice table එකේ record එකක primary key එක invoice_ID කියල ගමු.</span></p><p><span style="font-size: 12px"><strong>**</strong> Handover_Goods table එකට record 1ක් add වෙනකොට අර invoice_ID එක foreign key 1ක් විදිහට save වෙනවා.</span></p><p><span style="font-size: 12px"></span></p><p><span style="font-size: 12px">එතකොට මේ query එකෙන් ඔයාට ඕනෙ result එක ගන්න පුළුවන්.</span></p><p><span style="font-size: 12px"></span></p><p><span style="font-size: 12px"><strong>SELECT invoice_ID FROM Invoice</strong></span></p><p><span style="font-size: 12px"><strong>MINUS</strong></span></p><p><span style="font-size: 12px"><strong>SELECT invoice_ID FROM Handover_Goods;</strong></span></p><p><span style="font-size: 12px"></span></p><p><span style="font-size: 12px"><strong>P.S :</strong> මේක Oracle වලටයි ලිව්වෙ.</span></p><p><span style="font-size: 12px">අනිත් ඒවගෙනම් syntax පොඩ්ඩක් වෙනස් වෙනවද දන්නෙ නැහැ....</span></p></blockquote><p></p>
[QUOTE="kalhara96, post: 20657670, member: 300272"] [b]try this machan[/b] [SIZE="3"]මචන් මන් මෙහෙම හිතල උත්තරේ දෙන්නෙ. [B]**[/B] Invoice table එකේ record එකක primary key එක invoice_ID කියල ගමු. [B]**[/B] Handover_Goods table එකට record 1ක් add වෙනකොට අර invoice_ID එක foreign key 1ක් විදිහට save වෙනවා. එතකොට මේ query එකෙන් ඔයාට ඕනෙ result එක ගන්න පුළුවන්. [B]SELECT invoice_ID FROM Invoice MINUS SELECT invoice_ID FROM Handover_Goods;[/B] [B]P.S :[/B] මේක Oracle වලටයි ලිව්වෙ. අනිත් ඒවගෙනම් syntax පොඩ්ඩක් වෙනස් වෙනවද දන්නෙ නැහැ....[/SIZE] [/QUOTE]
Insert quotes…
Verification
Nawa warak dahaya keeyada? (Namaya wadi kireema dahaya)
Post reply
Top
Bottom