Need help to get right format date from SQL statement

[zwinfo]

SELECT Inventory.ProdCode, Inventory.Description, Inventory.Comments, Inventory.UOH, Inventory.UOO

FROM `F:\Solutions Accounting\Playground\Playground`.Inventory Inventory, `F:\Solutions Accounting\Playground\Playground`.`Purchase Order` `Purchase Order`

i try to setup a query through above statement. but what i get is not quite ideal. The same record will exist many times in many rows. so how i re-arrange the above statements to get right date formate: the same record exist once in a row ???

pls advise the detailed info.

thanks

[knicholson]

You need to join field(s) from table1 to field(s) in table2.

Ken