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,
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.
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.
Click Here to Expand Forum to Full Width