My list1 contain uid, password
my list2 contain uid , username ,sal;
result list3: uid username sal ,password.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pankaj Kumar ChoudharyPosted Mar 27, 2015, 5:31 AM
select list2.uid , list2.username ,list2.sal, list1.password
left outer join
list1
on
list1.uid=list2.uid