-
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
-
You need to join field(s) from table1 to field(s) in table2.
Ken
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|