[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
InstantDB: How do I insert a value from a select statement?
- To: <instantDB@enhydra.org>
- Subject: InstantDB: How do I insert a value from a select statement?
- From: "Steve Carton" <scarton@retrievalsystems.com>
- Date: Fri, 30 Mar 2001 14:17:27 -0500
- Reply-To: instantDB@enhydra.org
- Sender: owner-instantDB@enhydra.org
This doesn't work. How do I fill in the values
from two select statements?
e insert into linksubjects (LID,SID) values
({SELECT __IDB_INTERNAL last_value FROM TEXT("ID")
IN TABLE links FROM links},{select SID from
subjects where subject='OmniMark' ignore case});
Steve Carton
703/749-0012
www.retrievalsystems.com
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|
- Follow-Ups:
- Re: InstantDB: How do I insert a value from a select statement?
- From: "Peter Hearty" <pete@hearty.plus.com>
- Re: InstantDB: How do I insert a value from a select statement?
- Prev by Date: InstantDB: ALTER TABLE table DROP COLUMN bug
- Next by Date: Re: InstantDB: How do I insert a value from a select statement?
- Prev by thread: InstantDB: ALTER TABLE table DROP COLUMN bug
- Next by thread: Re: InstantDB: How do I insert a value from a select statement?
- Index(es):
