Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
matthew_moore_2
Starting Member
2 Posts |
 Posted - 2008-12-20 : 12:49:10
|
| Hello, I'm taking sql courses and I'm having trouble with a few statements1. Write an SQL statement that returns all columns in table A2. Write an SQL statement that returns all columns in table A where inv is 13. Write an SQL statement that returns all columns from table A and B where inv is equal I will really appreciate some help |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2008-12-20 : 13:02:15
|
| Typically we don't answer exam or homework questions. If you take a shot at it and post what you've attempted so far we'll guide you, but we can't write out the answer from scratch for you. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-12-20 : 13:10:55
|
| Does your course material not cover basic SELECT statements?--Gail ShawSQL Server MVP |
|
|
|
matthew_moore_2
Starting Member
2 Posts |
Posted - 2008-12-20 : 15:27:06
|
| These courses are through my job. I work at Chase and I just moved to another group because or the wamu/chase merge. No the material we received does not cover select statement |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2008-12-20 : 18:37:43
|
| Um, who is providing this course material, if I may ask? They want you to write queries and they don't cover the basic SQL statements? Unless I'm missing something this course is not going to teach you much.Here's a good intro site:http://www.w3schools.com/sql/default.aspTake a look at that and see what you can come up with, then come back here. |
|
|
|
Jai Krishna
Constraint Violating Yak Guru
333 Posts |
Posted - 2008-12-21 : 22:59:44
|
| See BooksOnLine For the Basics and u'll get examples on SELECT StatementJai Krishna |
|
|
|
JamesRyan
Starting Member
18 Posts |
Posted - 2008-12-22 : 05:37:42
|
| You should find a new course, or at least a good book! Hope this helps you out in the meantime... let me know if you need more help because it doesnt sound like you'll get it from the course 1 - SELECT * FROM tableA2 - SELECT * FROM tableAWHERE inv=13 - SELECT * FROM tableA INNER JOIN tableB ON tableA.id=tableB.idJames Ryanwww.sqlhowto.co.uk |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
|
|
New to forum, need help!!!