[andreasberglind]

Should this work in MySQL?? All the ID-tables are primary keys in the table they belong to, but i have not made any Foreign keys in the Title table. Do i need that?

insert into title(GenreID,MediaID,ActorID,Movietitle)
values
(
(select genreID from Genre where Genre.GenreName = 'Action'),
(select MediaID from Media where Media.MediaType = 'DVD'),
(select ActorID from Actor where Actor.Name = 'Robert DeNiro'),
'Heat'
);

[tai fu]

What the???

Is that a language or just mysql commands??

Why not just try simple queries??

INSERT INTO title blablabla... VAlUES blablabal??

[andreasberglind]

I want to insert values from the other tables, so inserting direct values is no good. How would I get this solved? Index? how does that work? do i need it?

[nd2]

first you need mysql version 4.1 or greater for sub selects.

maybe you can dump a little bit of your database strture and a line of data on here so we can what you are trying to do, in most cases you dont need to use subselects.

[andreasberglind]

what I want to do is quite simple. I want to extract a value from, for instance, genre.genreID and insert it into title.genreID.

Maybe I can extract the value into a ASP variable, and then insert that? Am i getting closer?

Thanks for all the help...

[tai fu]

I dont know ASP , only PHP, but you have to notice here that you are changing Database
I quess the querries would be
SELECT value FROM genreID
and then change db and execute the query
INSERT INTO genreID VALUES ("value")

Those are your queries