Re: please help with sql query

2002-09-27 Thread Clive Smart
Hi there Try This: SELECT products.product_name, products.fg_number, images.image_name, images.thumbnail, images.image_path, images.color_depth, images.width_inches, images.height_inches, images.resolution, images.filesize, images.filetype, images.notes FROM products LEFT JOIN images ON produc

please help with sql query

2002-09-27 Thread Michael Knauf/Niles
I have two tables: products +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(6) |