Joins

2004-04-07 Thread O'Neill, Ciaran
Hi, I am only a very occasional mySQL user and I need some help with a join. Our internal helpdesk is done in mySQL and PHP. I have been asked to dump some of the contents of the database into a file for loading into a data warehouse. The following query is getting the data from the workorders

Joins - extra info

2004-04-07 Thread O'Neill, Ciaran
By the way, we're using Version 3.23.49 on linux Ciaran. CiarĂ¡n O'Neill IT Department, United Drug Plc, Magna Business Park, Citywest Road, Dublin 24. * +353 1 463 2535 Fax +353 1 463 2397 * www.united-drug.com ** This

RE: Joins

2004-04-07 Thread O'Neill, Ciaran
That worked perfectly. I've never had much luck with joins! Thanks. Ciaran. -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: 07 April 2004 12:52 To: [EMAIL PROTECTED] Cc: O'Neill, Ciaran Subject: Re: Joins * O'Neill, Ciaran [...] I want to get everything from