Write sql query joins tables example database uses jobs

...For example, click button one can copy project name and dates fields to task project name and dates, click button two can copy ETA and ETD from project to task ETA and ETD, click button three will copy project ETA 2 and ETD 2 to task ETA and ETD fields, etc... And it won't affect the original data in project, only for the individual task. - Batch update in task/project, A question about batch update for task, for example, list view in task, and select all the tasks I want, say 90 tasks, then update certain field data, like tracking status - When the project is created, auto copy the project’s name to Exhibition. Please see the screenshot. Same thing in task, once select the customer, it will update the title. - Once new task is created (saved), it will update ...

Hello, i have python codes that fetchs some data.i need someone have experience in qt designer to create the win form To show the data as required some in lables and some tables and need the design visually so we can easly edit in future Will explain the required design privately sharescreen in anydesk..

I'm in need of a skilled developer who is proficient in a variety of programming languages and can work on two key areas of my website. - Basket Featur...registration, the user remains on the registration page. This is not the intended behavior, and I need a solution that will ensure that users are correctly redirected to their profile page post-registration. . This video helps what im trying to say. Ideal candidates for this project should have a strong command of HTML, JavaScript, CSS, PHP, and SQL. In addition, experience with Stripe payment integration and troubleshooting registration processes on websites is highly desirable. Please note that these two tasks are interdependent, and hence, need to be addressed simultaneously.

I am currently facing an issue with my website - when a user registers on the site, instead of being redirected to their profile page ...redirected to their profile page or login page, the system keeps them on the same page. Furthermore, upon this failure to redirect, it shows it is successful when registering but doesn't take to another page. I need someone with strong proficiency in HTML, CSS, JavaScript, PHP, and SQL to diagnose the problem and implement a solution so that after successful registration, users are seamlessly taken to their profile page. The ideal candidate should have: - Significant experience in PHP, HTML, CSS, JavaScript, and SQL. - Proven track record in troubleshooting and rectifying website issues. - Firm understanding of user authentication a...

hello amazon sp installation do you have apibilgi When we query with asin, can we retrieve information about the products? Example: B01234345 brand, sales, ranking, seller, number of offers etc. information

Application code to implement Roomio as a web application in python. You will use the table definition posted at the end of this document.

I am looking for a skilled graphic designer to create a mo...not like how it looked “childish” or “bubbly”. I would like it to look more aggressive with sharp edges. Additionally I have also provided some old Nike logos that I like to give you an idea. Also the logo should be easily printable to apparel so the logo should be black & white. What is your price? How many revisions do I get? Key Project Details: - Type: Logo Design - Style: Modern Primary Uses: - Website - Print (Business cards, brochures) - Merchandise (T-shirts, mugs) The ideal candidate will have: - Strong portfolio of modern logo designs - Ability to design for both digital and print mediums - Experience in creating logos that work well on merchandise Please include a link to your ...

...optimization based on the patterns and anomalies identified. Details about the data: I want to have 3 tables: Real time data table: The data will be captured directly from sensors at the form of columns, for example, Device 1, device 2 , device 3, and rows are time captured at growing rate of 1s. the value of the row is the energy consumed of that device at that exact second. This will be a large table. Hourly Data Table: Aggregate data hourly to feed into the anomaly detection model, stored in the 'Hourly' table, to identify significant deviations. Daily Data Table: Summarize daily data for use with the SARIMA model, aiding in long-term consumption predictions and trends analysis. All the tables are fed from the main large table (secondly rate table -...

...and playful, with a bright and colorful color scheme. It's important that the design is engaging and reflects the vibrant nature of our business. The brand "Below Ground Bliss" is focused on providing homeowners with quality products and services for use in their basements. Services would include HVAC, Electrical, Sump Pumps, Basement Remodeling, etc. Products would be fun Man Cave items, pool tables, wine storage, bar, home theater etc. The ideal logo would show the ruggedness and roughness of basements with soft, playfullness of a new living/fun space. Ideal Skills and Experience: - Proven experience in creating fun and playful logo designs - Strong understanding of color theory, particularly in creating bright and colorful palettes - Ability to balance simpli...

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I'm looking for a skilled developer who can customize the Chatify platform to support two separate tables for Users and Admin to login and chat between each other. Key Deliverables: - Ensuring users can login and chat between tables Ideal Skills: - Proficiency in Chatify platform (Open Source) - Experience with database management and customization - Strong understanding of user authentication and interaction - Ability to create a seamless, user-friendly interface

I'm looking to automate a process in my manufacturing setup. This involves controlling a servo and timer to carry out specific tasks. Key Responsibilities: - Develop a system that uses a combination of a servo and timer to automate a particular process in my manufacturing facility. - Ensure the system is able to operate efficiently and with high precision. Ideal Skills: - Proven experience in automation projects, particularly in a manufacturing setting. - Proficiency in programming and working with servos and timers. - Strong problem-solving skills to optimize the automation process. Note: I'm unsure about which platform would be the best for this project. I'm open to suggestions and recommendations.

I need an expert in SQL Server Report Builder 3.0 to help rejuvenate some lab reports. I require some amendments to be made to the current reports I have. Key Tasks: - Altering the way data is presented within the reports - Incorporating new fields to the current reports In the end, I need the same data results but with improved visibility and understanding. Ideal Skills: - Appropriate familiarity with SQL Server Report Builder 3.0 - Strong grasp of data visualization principles - Detail-oriented and precise to ensure report data remains accurate. Individuals that can deliver these changes precisely and quickly are highly preferred.

I need a skilled freelancer to extract table data from a PDF file. The extracted data will be used for analysis in a Microsoft Excel spreadsheet. Key Requirements: - Extract tables from a PDF - Ensure data quality and integrity - Deliver the data in a Microsoft Excel format Ideal Skills: - Proficiency in PDF data extraction - Strong understanding of table structures - Experience in working with Microsoft Excel - Attention to detail and accuracy is crucial look attached PDF and EXCEL then Bid, start Bid writing PDF and sample attached. So I know you look my file

I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula error...are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA shift and 2 middle shifts, i want a report table showing me this for all the employees. i also want to be able to edit the fields and tables if required at a later stage. FOR AN EXCEL EXPERT THIS IS A 20 MINUTE TAS...

Hi I will share the details with the shortlisted candidates. Thanks

Assist in writing answers for 3 questionnaires for Grant application criteria for an Allied Health Company demonstrating the company's setup All answers for the criteria's are to be written within 750 word limits each. Assessment Criterion 1: Service delivery [750 word limit] Describe how your organisation will deliver the services in the identified ACPRs in the application. Assessment Criterion 2: Stakeholder Engagement [750 word limit] Describe how your organisation will cultivate or expand links with other service organisations, infrastructure and resources, including the Regional Assessment Services (RAS) and other relevant specialist services e.g. dementia supports. Assessment Criterion 3: Efficient and Effective Use of Grant Funds [750 word limit]

I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.

I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.

I'm looking for a proficient developer who can add a page to my website that interfaces smoothly with my MySQL database. The website already has formatting etc, so I'm not looking for that. The database stores a variety of exercise data, and the webpage needs to display this data in an intuitive and user-friendly manner. Key webpage features include: - Display of exercise data: Each exercise's description and its difficulty level should be displayed. There's also a column in the database containing YouTube URL links, so another important feature the webpage needs is the ability to watch these exercise videos directly from the webpage. It is a simple database with only one table. - Users should be able to select the exercise they want from ...

I'm in need of an Excel expert who can assist me with data analysis, formulas, and ...preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and manipulate pivot tables. - Macros: The project involves basic macro creation and execution. - Conditional Formatting: You should be able to apply conditional formatting to present data in a more user-friendly manner. If you believe you have the right skill set for this project...

Please Sign Up or Login to see details.

Hi, we need to create a picclick similar site that uses the feed of our 2 websites The site will automatically download the products by comparing and redirecting them and showing the offers of the two stores.

I need a comprehensive HTML/CSS solu...need a comprehensive HTML/CSS solution for my report pages. it must be clean code with easy names class and id's not generated with ai Key Requirements: 5 pdf files not just this one . - Create inputs: I'm in need of a web developer to build inputs that can be used to create a real report. - Input types: The report inputs should include text, number, and date inputs, as well as checkboxes and tables. - Layout: The layout of the report pages should be exactly as shown in the sample page I will provide. Ideal skills for this job include: - Proficiency in HTML, CSS, and JavaScript. - Experience with form creation and layout design. - Attention to detail to ensure the layout is replicated accurately. i have x5 reports needed to be d...

I have a single image that I need to have enlarged. Right now, it's fairly small, and I require a high-quality enlargement with advanced techniques. Key Requirements: - Image Enlargement: The image needs to be stretched to a larger size while maintaining a high level of quality. - Advanced Techniques: It's important that the resizing process uses advanced techniques to ensure the quality of the image is not compromised. Ideal Skills and Experience: - Image Editing: You should have a strong background in image editing, particularly in the area of enlargement. - Advanced Techniques: Experience with various advanced techniques for image resizing will be highly beneficial. Overall, I'm looking for a freelancer who can deliver a high-quality enlargement of my image. P...

I'm looking for a skilled transcriptionist to convert my lengthy PDF manual into a typed format. Here are some key details: - The manual exceeds 100 pages, making the task time-consuming and demanding attention to detail. - The manual is text-based, with tables and diagrams. A Procedure Manual. The ideal candidate will: - Have prior experience in transcription, specifically with lengthy documents. - Be proficient in English, ensuring an accurate transcription. - Be detail-oriented and able to maintain high standards throughout the task. Ensuring the accuracy and completeness of the transcription is crucial. This will be the foundation upon which other team members will build on.

3D modeling of a villa in Revit: 1. Copy architectural model to construction: - Levels - Axes - Columns - Walls - Ceilings 2. Adding column sections - Wall sections - Beam sections 3. Connecting columns to ceilings 4. Linking beams to levels 5. Openings: windows and doors 6. Tables of quantities for concrete + blocks + iron.

I am looking for a skilled and experienced Full stack developer with Hands-on experience in Java Hands-on experience in Angular/ REACT Hands on experience on AWS RDS/AWS S3/Oracle/AWS Athena/ SQL In-depth knowledge in Core Java, Spring framework and RESTful API Services, Apache Camel, CI/CD Jenkins, Containerization Experience with AWS Cloud and its services like EC2, Athena, Lambda, S3, SQS and Cloud Formation Experience in writing JUnit test cases Problem-solving abilities

...Engineer or Architect who can handle data export processes, model and create tables and entity relationships, and develop an efficient and scalable database within a tight one-month deadline. ### Responsibilities: - Data Integration: connect and streamline data from multiple sources including ad platforms (like Google Ads, Facebook), website analytics tools (e.g., Google Analytics), CRM systems (e.g., Salesforce), and MAPs (e.g., HubSpot). - **Accelerated Database Design:** Design and implement a robust and scalable database that supports efficient data aggregation and analysis, within a short timeframe. - Entity-Relationship Modeling: Develop and finalize a comprehensive ER diagram that illustrates the database structure and supports urgent marketing...

Good morning, for my client i need to make an implementation on WooCommerce - on the store the client selects a product and then the website sends a query to the website - provide the number of products on the network. The system will then return a list of places with available quantities of a given product. The system API is in JSON format. An authorization token is required to execute the query.

I'm seeking an individual who can create a one-time web scraper that can collect text, images, and tables from Website 1. The project involves: - Developing a tool to scrape text, images, and tables from the specified website. - Ensuring the tool can operate efficiently for a one-time scraping process. Key Skills: - Proficiency in web scraping tools and techniques. - Experience in scraping text, images, and tables. - Ability to create a custom scraper for a one-time scraping task.

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I'm in need of an experienced backend developer to create a mail parser with the following specifications: - **Email Protocol:** The mail parser should support SMTP, so proficiency in this area is a must. - **Primary Goal:** The primary function of this mail parser should be storing emails in a MySQL database. If you have experience with database integration, this would be a big plus. This project requires expertise in backend development, specifically with an understanding of how SMTP works. You should also be familiar with MySQL and have experience in integrating databases into applications. Please provide examples of similar projects you've worked on in your proposal. Thank you.

I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.

I need a VA with Wix store experience, a keen eye for detail, and proficiency in spreadsheet management. You'll be tasked with: - Keyword Optimization: Adjust the product titles on my Wix store to ensure they are optimized for search engines. Experience with SEO would be beneficial for this. - Database Creation: Develop a comprehensive database for all my products. This will include attributes like Product names, Product prices, and Product URLs. - Formatting: The database should contain separate columns for each product attribute. Strong organizational skills and experience with data entry would be ideal. Ultimately, the goal is to streamline the management of my product listings for a smoother business operation. Prior experience with Wix and creating pro...

I'm looking for an experienced developer to integrate Typesense search functionality with my web application. My site primarily uses JavaScript, and I want to make the product listings searchable through Typesense. Key Requirements: - Integrate Typesense search with my existing web application that is built in JavaScript. - Implement real-time search capabilities for product listings. Ideal skills: - Strong experience in JavaScript - Previous work with Typesense or similar search engines - Understanding of real-time search functionality This is a critical project as real-time updates are key for my product listings. Please provide examples of your previous work with Typesense or real-time search in your bid.

...application assistance. Scope of Work: The project encompasses the following key tasks: Template Customization: Adapting the AI SaaS Dashboard template to fit the unique branding and functional requirements. Database Integration: Configuring and linking an external Airtable database to import and regularly update a directory of funding opportunities. User Authentication and Profile Setup: Developing secure login/logout capabilities and user profile management. AI Chatbot Development: Integrating OpenAI’s ChatGPT API to create an interactive chatbot that conducts a business background quiz and uses responses to tailor funding recommendations. Opportunity Matching System: Implementing algorithms to match users with funding opportunities based on quiz resul...

I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.

I'm looking for a skilled individual who has a good understanding of Mechanical Engineering and Data Science to help me set up a database that records the live feed of on-board sensors in a car. Key Responsibilities: - Utilizing an On-Board Diagnostic Tool and an app to record the data - Implementing a database to store the collected sensor data - Analyzing the data primarily for predictive maintenance using statistical analysis Ideal Skills: - Mechanical Engineering background - Proficiency in working with On-Board Diagnostic Tools - Strong experience in statistical analysis - Knowledge of database management systems and data analysis tools - Experience in predictive maintenance is a plus This project requires attention to detail, analytical thinking, and the...

I'm in need of a talented 3D designer that can create realistic renders of melamine furniture pieces. - The furniture type is melamine, and it will consist of a combination of kitchens, wardrobes and tables. - The finish for this furniture is a custom color, which will be provided by me. - I'll need the designer to work on standard dimensions for the pieces, as I don't have specific measurements. Ideal Skills: - Proficiency in 3D design software - Experience in rendering furniture with decorations - Ability to work with custom colors - Understanding of standard furniture dimensions - Attention to detail and a keen eye for realism Please provide samples of previous work in a similar vein.

I am searching for a Product Analyst who can apply their knowledge towards data analysis, market research, and performance monitoring. Its a small assignment This assignment involves diving into a snowflake database to explore how customers behave. The goal is to find useful information that can help the Product team make decisions to make the business grow. After you uncover insights, you'll suggest changes to the product, like adding new features, making current features better, or even getting rid of features that aren't working well. You need to do the analysis, create graphs to show your findings, share all the code you used, and also come up with a plan for an A/B test to try out one of your suggested changes. Note: Its a short assignment, not spend more than tw...

...performing poorly with slow website loading times and database slowdowns, which is unacceptable as I regularly have more than 500 concurrent visitors. The primary focus of this project will be optimizing the server's Plesk settings, Postgres and MariaDB databases, and PHP 8.2 configuration. Key tasks will include, but are not limited to: - Configuring Plesk for optimal performance, including adjusting server pool size - Identifying and implementing improvements to Postgres and MariaDB settings to reduce slowdowns - Tuning PHP 8.2 to enhance website speed and performance Ideal candidates for this project will have: - Proven experience in optimizing dedicated servers, particularly with Plesk and Almalinux - A solid understanding of database optimization, including ...

Please Sign Up or Login to see details.

I need some help with a data model I created in Power Pivot. I have 2 data sets: one is Sales and the other is Stock. I have added both data sets to my data model and am now trying to create a pivot which pulls data from both tables. My Sales table pulls the data perfectly but the Stock table does not. Some context... When I pulled the data into the data model I added a column which I called DataModelLink. This created a 1 (Sales) to many (Stock) relationship between the two tables. As an example, I tried to pull the data of one particular style which had one line in the Sales table but 2 lines in the Stock table. For this reason, my Pivot is only reading one of two of the lines on the Stock data table. I am happy to share the data model as it is only sample data...

Able to follow instruction, can be done in 3 days. CRUD for 3-4 tables only

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I am seeking a detail-oriented freelancer who can expertly transfer text data from PDF files into a database. The ideal candidate should possess the following skills and experience: - Proficiency in working with PDF files - Expertise in data entry tasks - Experience in formatting and structuring databases - Excellent attention to detail Suitable candidates need to handle copious amounts of text data, accurately convert the text-containing PDF files into a structured and organized database. This includes careful validation to ensure no data is lost or misrepresented during the data entry process.

Hi Ashish, this is for the tasks I emailed about.

...interest and a data analysis plan. State the variable types and specific analyses needed. Using the data provided (see attachment) , create a tables: Table 1 - demographics based on comparison groups, Table 2 - outcome table other associated variables with comparison groups, and Table 3 Analysis - multivariate analysis of your choice and written interpretation of the analysis. Section 2 - Scenario Two Scenario: Based on scenario 1 in this section, you have been asked to detail the epidemiological background of the outcomes of interest, obesity and physical. Instructions: You have 2 pages (minimum) to write an epidemiological report on obesity. Be sure to include and describe, in detail, the 4 areas below: Past and curre...

I'm searching urgently for an experienced PHP architect who can const...items. - Integrating an 'Add to cart and checkout' feature ensuring a simple and smooth transaction process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for payment method integration at the moment, the ability to seamlessly add these in the future is essential. My project requires immediate attention and the chosen freelancer needs to be able to commit and delive...