Announcements
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;
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156