SQL - Join two fields in the same table to a single field in another table -


i'm working on way lookup description code appears in 2 fields of same table.

the table/field names :

contacts  name, group_1 , group_4  lookup lookup_id, lookup_name

contact.group_1 , contact.group_4 both refer values in lookup.lookup_id , need resolved corresponding name values in lookup.lookup_name.

how can connect both fields lookup table , have them bring respective lookup_name values ?

left join contacts lookup twice. once group_1 , once group_2. left join instead of inner join, may have contact without 2 groups.

select c.name,        g1.lookup_name,        g2.lookup_name   contacts c        left join lookup g1 on g1.lookup_id = c.group_1        left join lookup g2 on g2.lookup_id = c.group_4

Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

jquery - How would i go about shortening this code? And to cancel the previous click on click of new section? -

my code below changes image people in team sector, can see theres alot of repeated code; there way shorten it? also currently, allows click on sections without turning off clicked one; assume toggle() function, couldn't work other way! still quite new jquery coding, grand!! cheers in advance! $("#team_client_services").click(function () { if ($(".team_client_services").hasclass("team_hide")) { $(".team_client_services").toggleclass("team_hide"); $(".team_client_services2").toggleclass("team_show"); } else { $(".team_client_services").toggleclass("team_hide"); $(".team_client_services2").toggleclass("team_show"); }; }); $("#team_management").click(function () { if ($(".team_management").hasclass("team_hide")) { $(".team_management").toggleclass("team_hide"); $(".team_management2...
Read more