Re: MySQL JOIN syntax question

2001-11-21 Thread Ian Barwick
On Wednesday 21 November 2001 03:01, James O'Brien wrote: > I have been trying to perform a join with several tables and I am having no > joy. error messages would increase the understanding of exactly what joy you aren't having ;-) > Can some one send me a query (just a select * is fine) for th

MySQL JOIN syntax question

2001-11-20 Thread James O'Brien
I have been trying to perform a join with several tables and I am having no joy. Can some one send me a query (just a select * is fine) for these tables the ID's i'm using below aren't the real column names but they will do for the purpose of this email. select * from table1 left join table2 on