SQL multi-queries...beginner
SQL multi-queries...beginner
(OP)
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.
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.





RE: SQL multi-queries...beginner
RE: SQL multi-queries...beginner
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: www.essexsteam.co.uk
RE: SQL multi-queries...beginner
Cheers,
Do.