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 IN

SELECT all except ... ?

2005-12-08 Thread Frank Rust
? -- Frank Rust, Technische Universität, Institut für Theoretische Informatik Tel.: +49 531 391 9525 Postfach 3329, D-38023 Braunschweig Fax.: +49 531 391 9529 Mühlenpfordtstr. 22-23, D-38106 Braunschweig -- MySQL General Mailing List For