Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-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!

*Tek-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

Subquery in INSERT Statement

Subquery in INSERT Statement

Subquery in INSERT Statement

I am trying to add records to a table which is located in my ERP Software (which is JD Edwards).  I have a simple INSERT statement (in Microsoft Access) that works if I manually include the data that I want inserted it works fine...BUT...I have a table that I imported from excel and it want to use this as reference for the data insert.  I hope I am being clear here.  Basically, I have a excep spreadsheet filled with the info I want to Insert into a table located in my ERP Software.  HELP and THANK YOU!!!

-Carla C. Hertel

RE: Subquery in INSERT Statement

If your source and target tables are in the same database instance, instead of using a values clause you should be able to do something like:
insert into target_tab (col_a, col_b, col_c)
select a, b, c from source_tab;

I'm not familiar with JD Edwards, so this syntax may not be exactly correct for its RDBMS.

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 Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

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

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close