×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

SQL multi-queries...beginner

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.

RE: SQL multi-queries...beginner

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.

RE: SQL multi-queries...beginner

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

RE: SQL multi-queries...beginner

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

Cheers,
Do.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources