Posted by Micha Biegnol� on 04/10/05 17:06

Hi, I am a student of multimedia design.

I have two tables in a database with one same column(column:Name).
I ask data from table1 collumn:Name. In table2 I want to use the return of
data from table1 and search table2 collumn:Name for other information. I
tried joined SELECT, but it didn't work with me.

I hope someone understands what I mean, my english is not so great.

select data from table1.
SELECT name FROM table1 WHERE movies='yes'

Then I want to select from table2 using the result of select from table1.

SELECT * WHERE..?

Thank you!

[Back to original message]