Re: LEFTJOIN ???

[Tony Mole]

Aha - finally made some progress... the code I posted above does now work in PHPMyAdmin... when I looked at the ANALYZE TABLE results I thought perhaps the fact that there was no identified unique column would cause confusion.

So I have assigned a unique column on each table and now it works :)

OK, so it doesnt work from my PHP script;

mysql_query ( "SELECT stock_price.Man_Pt_Nr, stock_price.Sup_Pt_Nr, stock_price.Manufacturer, stock_price.Description, stock_total.Qty, stock_price.Cost, stock_price.RRP, stock_price.Weight, stock_price.ETA, stock_price.Disti, stock_price.Condition FROM stock_price LEFT JOIN stock_total ON stock_price.Sup_Pt_Nr = stock_total.Sup_Pt_Nr" );

But - thats another forum I guess :)

Thanks for the pointers Peter.

Kind Regards