to fix my previous script error

SELECT a.BoxId, MAX(b.field1) as value1 , MAX(c.field1) as value2, MAX(d.field1) as value3, MAX(e.field1) as value4

FROM boxes a LEFT JOIN widgets bb ON...

as your desire ,you can do is ,

table address

addressid

address

town

postcode

table customer

customerid

Customer Forename

Customer Surname

addressid

Email

table supplier

Supplier ID

Supplier Name

addressid

Supplier Tel No

table product

productid

Category

productname

Price

productstock

Stock ID

Stock Description

productid

Qty in Stock

Table order

oderid

productid

customerid

orderdate

table orderdetail

orderdetailid

orderid

qty

and the primary key...