Trouble with a mysql statement

Not unique table/alias

[UrbanEcho]

Here is my statement:

$tracks_query = tep_db_query("select mix.mix_id_number, mix.mix_track_number, mix.mix_track, mix.mix_label, mix.products_id, products.products_id from " . TABLE_DJ_MIXES_INFO . " mix, " . TABLE_PRODUCTS . " products left join " . TABLE_PRODUCTS . " on mix.products_id = products.products_id where mix.products_id = products.products_id order by mix.mix_track_number");

I get 1066 - Not unique table/alias: 'products' back.

Any ideas what I am doing wrong?

TIA

Ian

[UrbanEcho]

worries, I figured it.

Don't you hate it when that happens :-)

[DrDoc]

Glad you solved it!

Welcome to Webmaster World!