Asume we have three tables:
CREATE TABLE ARTIST (Artistname TEXT UNIQUE)
CREATE TABLE SONG (SongTitle TEXT UNIQUE)
CREATE CHART(Artist INTEGER, Song INTEGER)
CHART.Artist should hold ARTIST.ROWID
CHART.Song should hold SONG.ROWID
Is it possible to do something like "INSERT INTO CHART(Artist, Song)
Values('Abba', 'Dancing Queen') + something to obtain the result
1. Insert (if not exists) 'Abba' into ARTIST
2. Insert (if not exists) 'Dancing Queen' into SONG
3. Insert into CHART with corresponding ROWID’s
Michael from Sweden
--
View this message in context:
http://www.nabble.com/Newbie-question-%22INSERT-INTO%22-on-joined-tables-tf4781848.html#a13680160
Sent from the SQLite mailing list archive at Nabble.com.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
