SQB DB complex query problem?
-
Hello, I am in a bit of corner here - I have a three tables in my DB. users(ID, login, fname, lname); relation(ID, userA_ID, userB_ID) and a temp table temp(ID, loginA, loginB). Temp table contains relation between two users in a manner of their logins. What I want is to update table "relation" according to "temp" so that all the relations would be bound by user ID's rather than logins. Could you help me out, please ? Thanks.
-
Answer:
insert relation (UserA_ID, Userb_ID) select A.ID, B.ID from temp T inner join Users A on A.login = T.loginA inner join Users B on B.login = T.loginB
Mantas D at Yahoo! Answers Visit the source
Related Q & A:
- How to convert sql query to Hibernate Criteria query?Best solution by Stack Overflow
- How to convert my SQL query to MS Access query?Best solution by Stack Overflow
- How to post an array of complex objects (that has an array of complex objects) with jQuery?Best solution by Stack Overflow
- How to write a complex query with doctrine?Best solution by Stack Overflow
- Can I use a 4 ohm crossover with a high pass slope of 24 db with a 6 ohm tweeter that has a 6 db slope?Best solution by termpro.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.