SQL question with limited privilege?
-
I have limited privilege in the sql database. Mainly Select statement commands. I need to select data by certain criteria then I need to take those results and query another table based on those results. ? ? ? Any ideas for the beginer sql?
-
Answer:
Do you know how to use inner joins? or "where exists"? I think one of those will help you. somewhat useless examples: Select tbl2.stuff from tbl1 inner join tbl2 on tbl1.key = tbl2.tbl1_key where tbl1.stuff='whatever' select tbl2.stuff from tbl2 where exists (select * from tbl1 where tbl1.key=tbl2.tbl1_key)
Connie00... at Yahoo! Answers Visit the source
Related Q & A:
- Where Can You Buy Beats By Dre Limited Edition?Best solution by ebay.com
- What Is A Limited Liability Corporation?Best solution by Yahoo! Answers
- How can I optimize this dynamic SQL query in oracle with PL/SQL?Best solution by docs.oracle.com
- How do I display limited html content in a webview?Best solution by Stack Overflow
- In what late models chevy trucks can i find 3:73 limited slip rearend?Best solution by Yahoo! Answers
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.