= fkisbn INNER JOIN author on fkauthor_id =
pkauthor_id
WHERE module_nr = ? group by IFNULL(image,'no_image.jpg'),title,
subtitle, pkisbn, publisher;
Mimi
From: Mimi Cafe [mailto:mimic...@googlemail.com]
Sent: 20 May 2011 11:33
To: 'Anupam Karmarkar'
Cc: 'Guido Schlenke'; mysql@lists.mysql.com
Hi Mimi,
I'm not quite sure, if I did understand you right, but let's try the
following query:
select a.firstname, a.lastname, b.subject
from Author a, book_author ba, book b
where a.fkauthor_id IN
( select fkauthor_id, count(*) from book_author group by fkauthor_id having
count(*) 1 )
and
Hi Mimi,
I'm sorry, but my query doesn't work. In between I created 3 tables:
authors:
+---+--+--+-+-+
| Field | Type | Null | Key | Default | Extra
+---+--+--+-+-+
|
Hi Machiel,
I'm not sure if you like the method I use for Export from Oracle to MySQL
databases:
You need an ODBC DSN for each, source and destination DB. Then you create an
empty Access Database with a link to the Oracle Source table.
If the destination MySQL table doesn't yet exists, you