books

[jon]

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

 

[Granny Spitz via AccessMonster.com]

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));

 

[jon]

Thanks

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));

 

[²É¹Ì³à]

¸ðµÎ Á¤½ÅÀ» Â÷¸®°í ¿­½ÉÈ÷ °øºÎÇÏÀÚ

 

[²É¹Ì³à]

Á¤¸» ´À¸®³×..

 

[²É¹Ì³à]

¿Ö ÀÌ·¸°Ô ¾ÈµÇÁÒ

 

[Guest]

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]

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.