-
needing help with SQL in ms dynamics POS
i am trying to figure out how to create a simple query for items barcode number and for the item's qty. i know some basic SQL, but i can't figure out what to select with my select statements and FROM where? any help or direction to a MS dynamics SQL site would be helpful. i have been searching for a long time.
thank you so much,
Wirelsstrendz
-
MS dynamcs - this is an oracle forum
you need to select the items you want from the tables you have - noone can help you with that as noone has a clue what the structure of your tables are
-
Sorry about that. well my problem is that i can't figure out what the tables are. here is a screen shot of the pos running.
-
Originally Posted by wirelesstrendz
i am trying to figure out how to create a simple query for items barcode number and for the item's qty. i know some basic SQL, but i can't figure out what to select with my select statements and FROM where? any help or direction to a MS dynamics SQL site would be helpful. i have been searching for a long time.
Try here... http://www.microsoftdynamicsforums.c...ms/default.asp
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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
|
Click Here to Expand Forum to Full Width
|