By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,504 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

sql join update

100+
P: 232
i have two tables and i want to fill first table data with second one in condition that if employee 1 is in more than one group that the one which contains its neighbor also will be considered
Emp1,emp2,emp3,gp1,gp2,gp3
e1,e2,e3
Gp,emp
g1,e1
g2,e1
g2,e2
g3,e2
g4,e3
net result
e1,e2,e3,g2,g2,g4
Oct 28 '13 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,316
Your description doesn't make any sense. I have no idea how you got from your sample data to your results. I also don't understand how you structured your data.
Oct 28 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.