Issue with Inner and Left Join -



Issue with Inner and Left Join -

i writing query combines columns 2 different tables. reading info csv file , doing info reconcilliation. fields follows allow phone call both tables creditors , takers. creditors db has credit name, trade_acct_number, 2 distinct identifiers called trade_id , action_id. takers table on other hand has corresponding trading_account_num , it's 2 distinct identifiers trade_id , action_id.

here conditions; records matched on trading_acct_numbers. based on trading_account_num farther filter info based on trade_id , action_id. trade_id's 8 characters long; if there match on lastly 6 characters of trade_id reflect data; else check action_id.

here current query (written in sql server ce)

select cr.credit_name, tk.trade_acct_num, cr.credit_reg_num, tk.trade_id, tk.action_id [taker] tr inner bring together [creditor] cr on tr.trade_acct_num = cr.trade_acct_num substring([trade_id],3,8) = substring([trade_id],3,8) or tr.action_id = cr.action_id order bt tr.trade_acct_num

currently table have next issues. 90% of desired output matches rows takers table omitted totally. there match based on business relationship number trade_id null action_id causes row not outputted. there no outputs when there match on both trade_acct_num , action_id not trade_id. tried doing left bring together followed inner bring together did not help situation. please help , explain. thanks

a left bring together provide null values creditor fields. need allow possibility of nulls in trade_id or credit_id in joined creditors table. mike mentioned above, illustration info helpful.

select cr.credit_name, tr.trade_acct_num, cr.credit_reg_num, tr.trade_id, tr.action_id [taker] tr inner bring together [creditor] cr on tr.trade_acct_num = cr.trade_acct_num substring(tr.trade_id,3,8) = case when cr.trade_id null substring(tr.trade_id,3,8) else substring(cr.trade_id,3,8) end or tr.action_id = case when cr.action_id null tr.action_id else cr.action_id end order bt tr.trade_acct_num

this checking cr.trade_id null , if so, homecoming tr.trade_id evaluate true , go on test credit_id in same way.

join

Comments

Post a Comment

Popular posts from this blog

php - Edges appear in image after resizing -

php - Edges appear in image after resizing - i have implemented next function: private static function generatepicture($sizekey, $src, $initialwidth, $initialheight, $imagetype) { $destination = adimage::addsizekey($sizekey, $src); if (file_exists($destination)) { return; } $finalsize = adimage::$sizes[$sizekey]; $initialratio = $initialwidth / $initialheight; $finalratio = $finalsize["w"] / $finalsize["h"]; $newimage = imagecreatetruecolor($finalsize["w"], $finalsize["h"]); imagealphablending( $newimage, false ); imagesavealpha( $newimage, true ); $oldimage = imagecreatefromstring(file_get_contents($src)); if ($initialratio >= $finalratio) { $scale = $finalsize["h"] / $initialheight; $surpluss = abs($initialwidth - ($initialheight * $finalratio)); imagecopyresized($newimage, $oldimage, 0, 0, $surpluss / 2, 0, $finalsize["w"], $finalsize[&q
Read more

ios8 - iOS custom keyboard - preserve state between appearances -

ios8 - iOS custom keyboard - preserve state between appearances - i'm having performance problems custom keyboard i'm working on. loading words in spell correction tree takes quite bit of time. seems done each time keyboard appears - there way preserve state of keyboard? apps can suspend / resume etc - can't find documentation on how extensions, or if there's mechanism doing att all. thanks! you loading dictionary net or disk? first case nsuserdefaults, encoding (nscopying) options store info. can load in background. according docs, os typically kills extension process, so, think there no way prevent keyboard objects deallocation (you may utilize nskeydarchiver). ios8 ios-app-extension custom-keyboard
Read more

Delphi change the assembly code of a running process -

Delphi change the assembly code of a running process - i'm trying alter address 00741fa5 has push test.009e721c . alter push test.009e71c8 . procedure callback; asm force $9e71c8 end; procedure tform2.btn1click(sender: tobject); var ppid :dword; pprocess : cardinal; begin getwindowthreadprocessid(findwindow(nil,pchar('test')), @ppid); pprocess := openprocess(process_all_access, false, ppid); injectasm(pprocess, $741fa5, 10, integer(@callback), 0); end; here injectasm function (with error checking) function injectasm(process: longword; injectaddress, injectsize, codeaddress, codesize : integer): pointer; var csize, rsize : integer; replaced : array of byte; jmp : array [0..4] of byte; jmpaddress : integer; nopv : byte; : integer; nbr: ulong_ptr; begin //injectsize must equal or greater 5, because need space our //(far) jmp wwxxyyzz instruction //if there's no space, inject in place of few instructions if injectsize &
Read more