Need help to get right format date from SQL statement
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