sql server - Multiple Inner Join - SQL -


i have sql request doesn't work...i don't know why because i'm beginning sql...

select cdr.*,   p1.*,   p2.*,   p3.* dbo.t_cdr_appel cdr   inner join dbo.pos p1 on cdr.cdr_loc_code = p1.loc_code ,     cdr.cdr_loc_code 'sc%vi%' , cdr.cdr_type 'i%'   inner join dbo.pos p2 on cdr.cdr_last_redir_no = p2.post_type ,     cdr.cdr_loc_code 'ccn%' , cdr.cdr_type 'i'   inner join dbo.pos p3 on cdr.cdr_last_redir_no = p3.backup_number ,     cdr.cdr_loc_code 'voicemail%' , cdr.cdr_type 'if'

thanks help

your select statement 

select cdr.*,   p1.*,   p2.*,   p3.* dbo.t_cdr_appel cdr   inner join dbo.pos p1 on cdr.cdr_loc_code = p1.loc_code ,     cdr.cdr_loc_code 'sc%vi%' , cdr.cdr_type 'i%'   inner join dbo.pos p2 on cdr.cdr_last_redir_no = p2.post_type ,     cdr.cdr_loc_code 'ccn%' , cdr.cdr_type 'i'   inner join dbo.pos p3 on cdr.cdr_last_redir_no = p3.backup_number ,     cdr.cdr_loc_code 'voicemail%' , cdr.cdr_type 'if'

is same as

select cdr.*,   p1.*,   p2.*,   p3.* dbo.t_cdr_appel cdr   inner join dbo.pos p1 on cdr.cdr_loc_code = p1.loc_code   inner join dbo.pos p2 on cdr.cdr_last_redir_no = p2.post_type   inner join dbo.pos p3 on cdr.cdr_last_redir_no = p3.backup_number     cdr.cdr_loc_code 'sc%vi%' ,          cdr.cdr_loc_code 'ccn%' ,      cdr.cdr_loc_code 'voicemail%' ,      cdr.cdr_type 'i%' ,      cdr.cdr_type 'i' ,      cdr.cdr_type 'if'

so, problem where clause many combination of and conditions same columns cdr.cdr_loc_code , cdr.cdr_type. try replacing and or instead.

update: since p1,p2,p3 of same table, avoid duplicate columns, try this

select cdr.*, p.*  (    select *,     (case          when cdr_type 'i%' cdr_loc_code         when cdr_type 'i' cdr_last_redir_no         when cdr_type 'if' cdr_last_redir_no         else ''     end) tmp_col dbo.t_cdr_appel  ) cdr inner join dbo.pos p on    (case          when cdr.cdr_type 'i%' p.loc_code         when cdr.cdr_type 'i' p.post_type         when cdr.cdr_type 'if' p.backup_number         else ''     end) = cdr.tmp_col    (cdr.cdr_loc_code 'sc%vi%' , cdr.cdr_type 'i%') or    (cdr.cdr_loc_code 'ccn%' , cdr.cdr_type 'i') or    (cdr.cdr_loc_code 'voicemail%' , cdr.cdr_type 'if')

note: running query above might take while large tables. may want add conditions where clause further tuning. should put where clause sub query since cdr_loc_code , cdr_type of same table dbo.t_cdr_appel. check null or empty dynamic column tmp_col in order avoid joining tables on '' = '' or on null = null.

select cdr.*, p.*  (    select *,     (case          when cdr_type 'i%' cdr_loc_code         when cdr_type 'i' cdr_last_redir_no         when cdr_type 'if' cdr_last_redir_no         else ''     end) tmp_col dbo.t_cdr_appel             (cdr_loc_code 'sc%vi%' , cdr_type 'i%') or        (cdr_loc_code 'ccn%' , cdr_type 'i') or        (cdr_loc_code 'voicemail%' , cdr_type 'if') ) cdr inner join dbo.pos p on    (case          when cdr.cdr_type 'i%' p.loc_code         when cdr.cdr_type 'i' p.post_type         when cdr.cdr_type 'if' p.backup_number         else ''     end) = cdr.tmp_col , nullif(cdr.tmp_col, '') not null

Comments

Post a Comment

Popular posts from this blog

Command prompt result in label. Python 2.7 -

i want put result(output) of shell command label. command works, label shows "0", however, in command prompt, result shown correctly, need showed in label. doing ubuntu. myg1 = button(root, text="rodyti informacija", command=lambda: gauti()) myg1.pack(side=bottom) def gauti(): imti = tekstas.get("1.0", "end-1c") info = subprocess.call("id '{imti}' ".format(imti=imti), shell=true) w = label(root, text= info) w.pack(side = bottom) subprocess.call() returns exit code of process created (in case 0 success). if want text output of process, should instead call subprocess.check_output() .
Read more

javascript - How do I use URL parameters to change link href on page? -

i change href value of link using url parameters. example: default <a id="dlink" href="link-1">link</a> but, when user goes https://url.com/?dlink=link-2 it swaps out link new link <a id="dlink" href="link-2">link</a> first need value url. if you're not using javascript framework can create function using jquery. please check get url parameter jquery or how query string values in js it. after that, element "a" id , set value there. $("#dlink").attr("href", hreffromparam);
Read more

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -

so have domain nameservers pointed aws route 53. site hosted on ec2 instance , reachable resolves site.com, if input www.site.com. i'm curious how site resolve www.site.com. have under route53 domains hosted zone 2 additional record sets outside of ns , soa: a site.com ec2 elastic ip cname www.site.com ec2 public dns i can reach site using both site.com , www.site.com, resolve site.com. there way make if enter either, resolves www.site.com? at first, both should record set. a site.com ec2 elastic ip www.site.com ec2 elastic ip and need redirect setting in web server (nginx, apache, ..) following. (source: how redirect www non-www nginx on centos 7 ) redirect non-www www if want redirect users plain, non-www domain www domain, add server block: server { server_name example.com; return 301 $scheme://www.example.com$request_uri; } save , exit. configures nginx redirect requests "example.com" "www.example.com". not...
Read more