Hi Community,
I would like to locate PO in SQL and i wonder if you can help me to understand what are the SQL query I should be inputing.
Thank you!
Hi Community,
I would like to locate PO in SQL and i wonder if you can help me to understand what are the SQL query I should be inputing.
Thank you!
Hi, just to add a useful info
https://www.w3schools.com/sql/sql_where.asp
Hope this helps as well.
Thanks.
ZHU
Hi,
You can add one more filter with No.
SELECT *
FROM [Document No_]
where [Document Type] = 1 and [No_] ='YourPONohere'
Thanks Nitin, what if I only wants to select one purchase Order?
Hi,
You can use below
SELECT *
FROM YourTablenamehere
where [Document Type] = 1;
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,564 Super User 2024 Season 2
Martin Dráb 228,651 Most Valuable Professional
nmaenpaa 101,148