SQL HELP

[Arrow11]

machanla Invoice kiyala table ekak tiyanawa..meke customerts good receive unama hand over goods kiyala table ekakata watenna hadala tiyenne.habai handover table ekata data giyata invoice eken e data tika remove wenna ba.

Dan mata display karaganna ona handoverover table eke nathi invoice ekata witarak aithiu records tika!!eka ganne kohomada??


example invoice table example handover table
id name id name
1 ss 1 ss
2 bb 3 cc
3 cc
mata dan display karagaganne ona invoice table eke tiyana handover eke nathi data tika?me example eke widiyatanam 2 bb kiyana eka?

 

[Arrow11]

bump urgent!!!

 

[thinking_guy]

machanla Invoice kiyala table ekak tiyanawa..meke customerts good receive unama hand over goods kiyala table ekakata watenna hadala tiyenne.habai handover table ekata data giyata invoice eken e data tika remove wenna ba.

Dan mata display karaganna ona handoverover table eke nathi invoice ekata witarak aithiu records tika!!eka ganne kohomada??


example invoice table example handover table
id name id name
1 ss 1 ss
2 bb 3 cc
3 cc
mata dan display karagaganne ona invoice table eke tiyana handover eke nathi data tika?me example eke widiyatanam 2 bb kiyana eka?

Select invoice_table.*, handover_table.* From invoice_table Left Join handover_table on invoice_table.id = handover_table.id where handover.id = dbnull

Meka adala SQL version eke widiyata wenas karala try karala balpan.

 

[kalhara96]

MINUS operator එක use කරපන් මචන්

 

[Arrow11]

MINUS operator එක use කරපන් මචන්

kohomada machan oya union minus operation mage awul,normal edineda use wena operation walin witarai system gahuwe machan

 

[Arrow11]

Select invoice_table.*, handover_table.* From invoice_table Left Join handover_table on invoice_table.id = handover_table.id where handover.id = dbnull

Meka adala SQL version eke widiyata wenas karala try karala balpan.

Mokakda machan oya .* operation eka oka man dan nane
mysql v5 da koheda use karanne machan

 

[thinking_guy]

Mokakda machan oya .* operation eka oka man dan nane
mysql v5 da koheda use karanne machan

.* eken kiyanne fields okkoma select karanna kiyala. eka operator ekak nemeyi.

 

[Arrow11]

.* eken kiyanne fields okkoma select karanna kiyala. eka operator ekak nemeyi.

thnx machan GRN eka hadaganna ona una invoice eke ewa hadover ekata copy karala hand over nouna tika witarak balaganna ona une

 

[thinking_guy]

thnx machan GRN eka hadaganna ona una invoice eke ewa hadover ekata copy karala hand over nouna tika witarak balaganna ona une

Excel wala lookup function ekak daapan wade lesi.

 

[kalhara96]

try this machan

MINUS operator එක use කරපන් මචන්

මචන් මන් මෙහෙම හිතල උත්තරේ දෙන්නෙ.

** Invoice table එකේ record එකක primary key එක invoice_ID කියල ගමු.
** Handover_Goods table එකට record 1ක් add වෙනකොට අර invoice_ID එක foreign key 1ක් විදිහට save වෙනවා.

එතකොට මේ query එකෙන් ඔයාට ඕනෙ result එක ගන්න පුළුවන්.

SELECT invoice_ID FROM Invoice
MINUS
SELECT invoice_ID FROM Handover_Goods;

P.S : මේක Oracle වලටයි ලිව්වෙ.
අනිත් ඒවගෙනම් syntax පොඩ්ඩක් වෙනස් වෙනවද දන්නෙ නැහැ....