books "jon" <jon[ at ]nospam.com> 29.09.2006 23:43:56 I need to start learning SQL for access. I mainly use 97 but I also use 2003. Can any one suggest any good books to start of with please. Thanks Jon

Re: books "Granny Spitz via AccessMonster.com" <u26473[ at ]uwe> 30.09.2006 00:23:12 jon wrote: [Quoted Text] > I need to start learning SQL for access. > > Can any one suggest any good books to start of with please. SELECT "SQL Queries for Mere Mortals" AS Book FROM Michael INNER JOIN John ON Michael.Hernandez = John.Viescas WHERE ((AmazonPrice = $34.64) AND (Instock = TRUE)); -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access/200609/1

Re: books "jon" <jon[ at ]nospam.com> 30.09.2006 00:35:24 Thanks "Granny Spitz via AccessMonster.com" <u26473[ at ]uwe> wrote in message news:670a0d2da1404[ at ]uwe... [Quoted Text] > jon wrote: >> I need to start learning SQL for access. >> >> Can any one suggest any good books to start of with please. > > SELECT "SQL Queries for Mere Mortals" AS Book > FROM Michael INNER JOIN John ON Michael.Hernandez = John.Viescas > WHERE ((AmazonPrice = $34.64) AND (Instock = TRUE)); > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access/200609/1 >

Re: books "²É¹Ì³à" <pleemun36[ at ]paran.com> 30.09.2006 01:22:19 ¸ðµÎ Á¤½ÅÀ» Â÷¸®°í ¿­½ÉÈ÷ °øºÎÇÏÀÚ "jon" <jon[ at ]nospam.com> wrote in message news:451dacd6$1_1[ at ]glkas0286.greenlnk.net... [Quoted Text] >I need to start learning SQL for access. > I mainly use 97 but I also use 2003. > > Can any one suggest any good books to start of with please. > > Thanks > > Jon >

Re: books "²É¹Ì³à" <pleemun36[ at ]paran.com> 30.09.2006 01:24:04 Á¤¸» ´À¸®³×.. "jon" <jon[ at ]nospam.com> wrote in message news:451dacd6$1_1[ at ]glkas0286.greenlnk.net... [Quoted Text] >I need to start learning SQL for access. > I mainly use 97 but I also use 2003. > > Can any one suggest any good books to start of with please. > > Thanks > > Jon >

Re: books "²É¹Ì³à" <pleemun36[ at ]paran.com> 30.09.2006 01:24:44 ¿Ö ÀÌ·¸°Ô ¾ÈµÇÁÒ

Re: books Tom Wickerath 30.09.2006 09:33:01 But Granny, is that a normalized design....to have a Michael table and a John table? Hmmm.... Tom Wickerath Microsoft Access MVP http://www.access.qbuilt.com/html/expert_contributors.html http://www.access.qbuilt.com/html/search.html __________________________________________ "Granny Spitz via AccessMonster.com" wrote: [Quoted Text] > jon wrote: > > I need to start learning SQL for access. > > > > Can any one suggest any good books to start of with please. > > SELECT "SQL Queries for Mere Mortals" AS Book > FROM Michael INNER JOIN John ON Michael.Hernandez = John.Viescas > WHERE ((AmazonPrice = $34.64) AND (Instock = TRUE)); > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access/200609/1

Re: books "Granny Spitz via AccessMonster.com" <u26473[ at ]uwe> 30.09.2006 14:04:19 Tom Wickerath wrote: [Quoted Text] > But Granny, is that a normalized design....to have a Michael table and a John > table? There are so many names in the Authors table that it had to be partitioned. There's a Michael partition and a John partition, each with 10,000's of records. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access/200609/1