Re: Single query possible?

2008-11-22 Thread Shawn Green
Hi Frank, Frank Rust wrote: Hi there, I'm just trying to solve a little problem: There are two tables (simplified): CREATE TABLE article (ID int, Title varchar, ...other_data ); CREATE TABLE author (ID int,name varchar,article_ID int,...other_data ); Now I have a lot of articles. They have one

Single query possible?

2008-11-12 Thread Frank Rust
Hi there, I'm just trying to solve a little problem: There are two tables (simplified): CREATE TABLE article (ID int, Title varchar, ...other_data ); CREATE TABLE author (ID int,name varchar,article_ID int,...other_data ); Now I have a lot of articles. They have one or more autors, e.g. INSERT