Re: FN-FORUM: mysql!

date posted 30th May 2006 21:13

> SELECT time_id, book_id
> FROM times
> LEFT JOIN bookings ON bookings.time_id =3D times.time_id

Oops! Ambiguous time_id result column... this will work better:

SELECT times.time_id, book_id
FROM times
LEFT JOIN bookings ON bookings.time_id =3D times.time_id

Anthony
-- =

www.fonant.com - Quality web sites