|
Dothy (Civil/Environme)
1 Nov 04 22:00
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 (Industrial)
2 Nov 04 10:24
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.
字串4
johnwm (Computer)
2 Nov 04 23:39
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: www.essexsteam.co.uk
Dothy (Civil/Environme)
2 Nov 04 23:47
Thank you very much for your answers. It's been helpful.
Cheers,
Do.
（Click：）
|
Add TO Favorites
