[U2] [OT] Sql Query

2012-11-07 Thread Barry Rogen
Our environment here is changing considerably and the focus is more and more inclusive of Sql database(s). My knowledge of Sql extends slightly past the ability to spell it. If I could get some suggestions on some good venues to learn the query language for this new database, it

Re: [U2] [OT] Sql Query

2012-11-07 Thread Symeon Breen
November 2012 14:45 To: 'U2 Users List' Subject: [U2] [OT] Sql Query Our environment here is changing considerably and the focus is more and more inclusive of Sql database(s). My knowledge of Sql extends slightly past the ability to spell it. If I could get some suggestions on some good

Re: [U2] [OT] Sql Query

2012-11-07 Thread George Gallen
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Wednesday, November 07, 2012 9:45 AM To: 'U2 Users List' Subject: [U2] [OT] Sql Query Our environment here is changing considerably and the focus is more and more inclusive of Sql database(s). My knowledge of Sql

Re: [U2] [OT] Sql Query

2012-11-07 Thread George Gallen
: Wednesday, November 07, 2012 10:03 AM To: 'U2 Users List' Subject: Re: [U2] [OT] Sql Query I would advise that you learn about joins firste.g. http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.h tml -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] [OT] Sql Query

2012-11-07 Thread Bill Brutzman
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Wednesday, November 07, 2012 9:45 AM To: 'U2 Users List' Subject: [U2] [OT] Sql Query Our environment here is changing considerably and the focus is more and more inclusive of Sql database(s). My knowledge

Re: [U2] [OT] Sql Query

2012-11-07 Thread Bill Brutzman
Barry: Also... check out Lynda.com --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [OT] Sql Query

2012-11-07 Thread Barry Rogen
-Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, November 07, 2012 10:10 AM To: U2 Users List Subject: Re: [U2] [OT] Sql Query If your just interested

Re: [U2] [OT] Sql Query

2012-11-07 Thread Daniel Nelson
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Wednesday, November 07, 2012 11:18 AM To: U2 Users List Subject: Re: [U2] [OT] Sql Query Thank you all for places to get my foundation built. I think from there, I can build my own house Barry Rogen Senior Programmer/Analyst

Re: [U2] [OT] Sql Query

2012-11-07 Thread Bill Brutzman
... it is easy to traverse tables. Suggestions would be appreciated. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, November 07, 2012 10:03 AM Subject: Re: [U2] [OT] Sql Query I

Re: [U2] [OT] Sql Query

2012-11-07 Thread Brian Leach
: 07 November 2012 16:18 To: U2 Users List Subject: Re: [U2] [OT] Sql Query Thank you all for places to get my foundation built. I think from there, I can build my own house Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.com

Re: [U2] [OT] Sql Query

2012-11-07 Thread Wols Lists
On 07/11/12 16:31, Bill Brutzman wrote: While the given link is key... a bit of frustration that I have had with SQL is that... often I have data in more than two tables... following the first select list... there could be data in six or more tables. The joins that I have tried seem to max

Re: [U2] [OT] SQL Query

2012-11-07 Thread Stuart Boydell
On 07/11/12 16:31, Bill Brutzman wrote: The joins that I have tried seem to max out at like... three tables. in UV have a look at SET.SQL to tweak the workspace memory used for the current session. ___ U2-Users mailing list