SQL multi-queries...beginner

[Dothy]

Hello all,

I'm a SQL beginner so please excuse my most likely stupid questions...

First, I'd like to know if you can do several queries in one query window. For example, can you say first to delete all the results in a table, then let's say to copy certain columns from another table with aggregate functions, WHERE clauses, etc.. all that in the same query window?

Thank you very much to anyone who'll answer. It's been weeks I'm trying to learn SQL language for Access and the Help is not really helpful!

Cheers,
Do.

 

[automatic2]

Not sure about your query 'window', but as you could imagine, only one function at a time will be run against the data base. you could script any number of directives and send them to the intrepeter in series fashion.

 

[johnwm]

You mention 'SQL beginner' and then go on to talk about Access. You will find that Access SQL (more properly known as JetSQL) isn't exactly comparable to any other standard SQL, so a lot of queries written in proper SQL won't run 'as-is' in Access.

The correct reference for JetSQL is found (in a standard installation) in "C:\Program Files\Common Files\Microsoft Shared\Office10\1033\jetsql40.chm"

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

UK steam enthusiasts:

http://www.essexsteam.co.uk

 

[Dothy]

Thank you very much for your answers. It's been helpful.

Cheers,
Do.