Mysql and PHP Join Query

[fluiduk]

Hi All

What is the best/quickest way to achieve this.

I have two tables, one call product_info which holds the products information and one call product_availability which contains the latest stock figures.

I need a join query that creates a table with all the of the information combined.

The common field between them is product_sku.

It needs to be very quick, as there will eventually be 50000 unique records in each table.

Any ideas? Or gentle nudges in the right direction

Thanks
Aaron

 

[fluiduk]

Cool will give that a go, how would I then get that into a table, preferably without having to use repeats on PHP, thats what slows it right down.

Thanks
Aaron

 

[fluiduk]

Ok

Would you mind showing me how you would do it with a loop kind of method? Will have to do for now. Im not too sure if the way I would do it would be the best

Thanks
Aaron

 

[fluiduk]

Sorted it now

Thanks guys

aaron