Getting a missing expression error when inserting from another table

5 pts.
Tags:
SQL
SQL development
INSERT INTO dst_case1 (email) values  SELECT (email_addr) FROM siebel.S_CONTACT@TCCP.TMS.TOYOTA.COM where dst_case1.customer_id=siebel.S_CONTACT@TCC


Software/Hardware used:
sql developer
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    I'm not sure to understand what you are doing and what SQL variant you are using.

    This is a reference to a table:

    siebel.S_CONTACT@TCCP.TMS.TOYOTA.COM

    Can you explain what is each one of the parts that form that string?

    Also, this:

    dst_case1.customer_id

    Must be a column from the above-mentioned table, but it appears to me that it is not, as the customer_id is qualified with something different than the above table.

    What is this:

    siebel.S_CONTACT@TCC

    ?

    We really need more information.

    The only recommendation I can make by now is that you should try your subquery first, and integrate it into the INSERT statement when you are sure that it is correct.


    85,005 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: