numero = 38644
interpreted = N
texte = select distinct item1 from table1where item in(select distinct item2 from table1)order by item1, item2on 18/9/01 9:35 AM, Britt T. at Britt@fishingworld.com wrote:> Try these:> > http://www.sqlcourse.com> > This unique introductory SQL tutorial not only provides> easy-to-understand SQL instructions, but it allows you to practice> what you learn using the on-line SQL interpreter. You will receive> immediate results after submitting your SQL commands. You will be> able to create your own unique tables as well as perform selects,> inserts, updates, deletes, and drops on your tables. This SQL> tutorial currently supports a subset of ANSI SQL. The basics of each> SQL command will be covered in this introductory tutorial. Unless> otherwise stated, the interpreter will support everything covered in> this course> > > http://www.sqlcourse2.com> > This unique SQL Tutorial is the sequel to the highly successful> SQLCourse.com site and will provide you with more advanced> easy-to-follow SQL Instruction and the ability to practice what you> learn on-line with immediate feedback! You will receive immediate> results on a web page after submitting your SQL Commands. This> continuation course will provide you with critical need-to-know> advanced features and clauses of the SELECT statement that weren't> supported in the previous SQLCourse.com site. Everything you learn> here will be ANSI SQL compliant and should work with most SQL> databases such as Oracle, SQL Server, mySQL, MS Access, Informix,> Sybase, or any other ANSI SQL compliant database.> > If you're already familar with the basics of SQL, you can still use> this as a refresher, and practice some SQL statements.> > > > > >> SELECT DISTINCT ItemType FROM >> >> John.>> >>> I need to perform a query on an SQL datasource and summarize the results of>>> a couple of the columns in the table. To do this in WebCat is no problem,>>> but I can't figure out the equivalent syntax in SQL. Any help would be>>> appreciated.>>> >>> [search db=some.db&neItemIDdata=BLANK&ItemTypesumm=T&ItemCatsumm=T]>>> >>>
>>> >>> [/search]>>> >>> >>> >>> >>> ------------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list .>>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to>>> >>> Web Archive of this list is at: http://search.smithmicro.com/>> >> >> --------------------------------->> John A. Hill>> Oak Hill Software>> Website Development/Consulting>> john@oakhillsoftware.com>> >> ------------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list .>> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to>> >> Web Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
select distinct item1 from table1where item in(select distinct item2 from table1)order by item1, item2on 18/9/01 9:35 AM, Britt T. at Britt@fishingworld.com wrote:> Try these:> > http://www.sqlcourse.com> > This unique introductory SQL tutorial not only provides> easy-to-understand SQL instructions, but it allows you to practice> what you learn using the on-line SQL interpreter. You will receive> immediate results after submitting your SQL commands. You will be> able to create your own unique tables as well as perform selects,> inserts, updates, deletes, and drops on your tables. This SQL> tutorial currently supports a subset of ANSI SQL. The basics of each> SQL command will be covered in this introductory tutorial. Unless> otherwise stated, the interpreter will support everything covered in> this course> > > http://www.sqlcourse2.com> > This unique SQL Tutorial is the sequel to the highly successful> SQLCourse.com site and will provide you with more advanced> easy-to-follow SQL Instruction and the ability to practice what you> learn on-line with immediate feedback! You will receive immediate> results on a web page after submitting your SQL Commands. This> continuation course will provide you with critical need-to-know> advanced features and clauses of the SELECT statement that weren't> supported in the previous SQLCourse.com site. Everything you learn> here will be ANSI SQL compliant and should work with most SQL> databases such as Oracle, SQL Server, mySQL, MS Access, Informix,> Sybase, or any other ANSI SQL compliant database.> > If you're already familar with the basics of SQL, you can still use> this as a refresher, and practice some SQL statements.> > > > > >> SELECT DISTINCT ItemType FROM >> >> John.>> >>> I need to perform a query on an SQL datasource and summarize the results of>>> a couple of the columns in the table. To do this in WebCat is no problem,>>> but I can't figure out the equivalent syntax in SQL. Any help would be>>> appreciated.>>> >>> [search db=some.db&neItemIDdata=BLANK&ItemTypesumm=T&ItemCatsumm=T]>>> >>>
>>> >>> [/search]>>> >>> >>> >>> >>> ------------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list .>>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to>>> >>> Web Archive of this list is at: http://search.smithmicro.com/>> >> >> --------------------------------->> John A. Hill>> Oak Hill Software>> Website Development/Consulting>> john@oakhillsoftware.com>> >> ------------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list .>> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to>> >> Web Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Andrew Simpson
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...