Need help with the sql query
$10-30 USD
Πληρώθηκε κατά την παράδοση
Need help with the sql query for the following:
Need to add a subquery to the Supplier table script - select supplier ID (d1_fornece) and invoice date (d1_emissao) from table SD1330, join to SF1330 (as in the Invoice query) and then from that table to SE4330 where payment terms are in the field E4_DESCRI. Select only the most recent record, by invoice date, for each supplier. Join this back to SA2330 on supplier ID and then change Payment Terms from NULL to E4_DESCRI in the subquery.
Please help me on this one.
Thanks,
MMB
Ταυτότητα Εργασίας: #18686945
Σχετικά με την εργασία
30 freelancers κάνουν προσφορές κατά μέσο όρο $22 για αυτή τη δουλειά
I am oracle certified SQL developer. I can do this very well. Lets talk and solve this problem. I am waiting for your response
I m a database administrator with 8 years of experience in this industry. I read your project details and attached files and I understood your needs ,I can do what you want in the deadline just contact me and we can d Περισσότερα
Hi there! Have done this type of work before and am a SQL expert. Please feel free to message me with additional information or with questions if any, thanks!
hi i am expertise in sql server and sql querying please let me knowif you are intersted , ping me for more details
Hello dear, I see that you are needing help with a SQL query, I am SQL expert and I can help you with that. Contact me and I will solve it quickly.
Hey there, Longtime MySQL dev here, would be happy to help. Could you send me a database schema, and then we can figure things from there? Being able to see your DB structure would really help putting your proble Περισσότερα
I read your description carefully and I am very confident that I can complete the task. Please don't hesitate to chat with me to discuss further details about the script. Have a nice day. Best regards, Vasileios A.
I have good experience working with Sql queries for over 6 years. I have seen your project requirements and I am sure I would be able to complete this project as required in the given time frame.
HI I can easily and very quickly do this for you, in just a few hours. I have 15 years experience and have written thousands of complex Sql server Stored procedures, Triggers, Functions, tables sing T-SQL 2016/2014/2 Περισσότερα
Hi, Hope you are doing good. I have gone through the full project description carefully. As 7+ years experienced SQL server developer, I can finish this project for 2 days at free of cost since I am new to the freela Περισσότερα
hello i will be the good choice for this task having 3year experience in web development you may visit portfolio looking forward to get connected
I am working professional with 3 + years of experience database concepts and SQL database administration
Hello Sir, I can do this query FREE of cost for you. Just rate me 5 stars if you like my work. Regards, Faisal Saeed.
Call me on my cell. It will not take more than 10 mins to be done. (Nine Nine eight five nine two seven six seven three).
Hello sir, I use to work with sql server databases with more then 200 tables. Let me do this task with no delay .
Hello , I came across your project and would be a pleasure to offer my help on this task. Per the project description, the final target is to update the Supplier information with the most recent payment type. If Περισσότερα
I can give you the most efficient query. You will not have any performance issue. I am very familiar with the technologies you are looking for.
I have more 5 year of experience making complex SQL query in PostgreSQL, MySQL, Oracle, Vertica and SQL Server Databases, i can help you. Regards