Sql merge two tables with one common fields jobs

I'm looking to develop an integrated mobile application that will offer food delivery services alongside cab booking. I want this app to be available on both iOS and Android systems. Here's the primary features that I'm looking for: - **Real-Time GPS Tracking**: I want my users to be able to track the delivery of their food or the location of their cab in real-time. - **In-App Payment System**: A seamless and secure payment system that ensures a smooth transaction experience for my users. - **Ratings and Reviews**: A feature that allows users to rate and review the quality of both the food delivery service and the cab service. Ideal Skills and Experience for this job: - Proficiency in developing cross-platform applications for iOS and Android. - Experience in integrating G...

One month SMO, SEO and Google ads work

DA upto 40 DR upto 60+ TF upto 40+ CF upto 35 UR upto 70+ PA upto 35+

I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration

...for a seasoned Python developer who can assist in two main areas: - Creation of PowerPoint presentation using a CSV data file - Automate the process via a public URL to upload the CSM file Creation of Powerpoint Presentation The CSV file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a proficient Python Developer with a solid understandi...

I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.

I'm seeking a skilled web developer to update my current PHP website admin interface to utilize the Bootstrap 4 admin theme. The primary purpose of this admin section is to manage content, so I'm particularly interested in revamping the forms and input fields. Key requirements include: - Update of the existing admin interface to Bootstrap 4 admin theme - Focus on enhancing the forms and input fields - Implementation of data validation within the forms The ideal candidate for this project should have: - Proficient in PHP and Bootstrap - Prior experience in revamping website admin interfaces - Strong understanding of data validation techniques - A good eye for user-friendly design Your task will be to seamlessly integrate the Bootstrap 4 admin theme and ensure that...

Please Sign Up or Login to see details.

YOUR BID PRICE IS FINAL. NO LATER CHANGE ALLOWED. I need an Experienced WordPress guy to fix my two problems in two different WordPress site. One site has problem in loading Google Map, place prediction () and in another site, you just have to implement Subscription plan (all required plugins are already installed; you just have to follow support team documentation) Please complete within 3 days

I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts an...The specific functionality of the agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL is requ...

...error. Along with this, I can't download newer versions of WordPress. I also need to make sure that my website is compatible with Consent Mode V2. Your responsibilities include: - Diagnosing and resolving the checksum error that prevents me from updating plugins and downloading WordPress updates. - Ensuring the site complies with Consent Mode V2. - Conducting a thorough evaluation of the website to detect any other issues that could be causing the problem. Skills and experience needed: - Proficiency in WordPress, its functioning, and its common issues. - Experience with plugin management and troubleshooting. - Familiarity with web compliance, especially with Consent Mode V2. - Ability to work around potential issues caused by unc...

I need a quality writer with expertise in curating cocktail recipes to develop a summer-themed ebook. The intended audience is home bartenders and the recipes should be easy to follow using common household ingredients. Key requirements: - The ebook should include fewer than 50 unique alcohol-based cocktail recipes and food dishes. - Recipes should cover a range of spirits and styles, from classic to innovative. - Each recipe should come with easy to understand cooking instructions and accurate measurements. - Include high-quality images and illustrations for each recipe, if possible. - Easy-to-navigate layout with an index or table of contents at the beginning. Ideal Candidate: - Previous experience in recipe writing or food/cocktail blogging. - Strong kno...

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output f...

I'm seeking a skilled content writer to craft a detailed and informative article about coffee tables. The piece should be around 1,200 to 1,500 words and cover various aspects of coffee tables, including their history, different styles and designs, and material options. Moreover, I need the article to highlight the distinctions between residential and commercial coffee tables. Key points to consider: - Research and include the origin and history of coffee tables - Discuss popular styles and designs in the contemporary market - Elaborate on the differences between residential and commercial coffee table considerations - Write in a style that's accessible and engaging for a general audience - Must contain 3 to 5 links as references within the article, t...

...functions. The work will mainly focus on: - Implementing text input fields and dropdown menus: These are crucial elements for user interaction and data input. Your job would be to make them look and function as required. - Basic database functions: While the exact nature of these is yet to be decided, they will likely include retrieving and adding data. Your task will be to integrate these functions seamlessly into the site. Ideal skills for this project would include: - Proficiency in HTML, CSS, and JavaScript, with experience in creating user-friendly and responsive UIs. - Familiarity with basic database manipulation. - Good communication skills, as we'll need to discuss the project in detail. If you have experience with these technologies and can de...

Hi, I am looking for someone to help me with courier delivery plugin for Botble Laravel CMS. 1) Technical tasks for the delivery person part - I need to add the role of the delivery person (name, phone number, passport photo (2 photos), text fields for biography, login and password) - so that he can log in to his account via login password. - When a customer orders goods, the admin must assign delivery to a certain deliveryman (list of deliverymen) that he delivered the goods to the client and should be the delivery status (picked up the goods, on the way, delivered, canceled). - Deliverer should see how much what goods delivered, new ordered goods (from admin) - notifications of new orders in telegram bot for deliverymen 2) Inside the product in each article should genera...

I'm looking for a detailed and engaging article that introduces the reader to the world of large conference tables. This article should be between 1,200 and 1,500 words, and provide a mix of information and benefits that really sells the concept of these tables. Key Points to Cover: - Introduction to different types of large conference tables available in the market - Factors to consider when choosing the right large conference table - Benefits and advantages of utilizing large conference tables in a professional setting - Article needs to reference l3-5 links which will be provided upon awarding the project The target audience for this article is general, so the content should be approachable and informative to all readers. The tone should be professiona...

I'm looking for a skilled developer to create a website form for events. This form will be used for registrations and payments. Key requirements: - Integration of a form into the w...form for events. This form will be used for registrations and payments. Key requirements: - Integration of a form into the website - Capturing of standard user details; Name, Email, Phone number and Address - Additional fields for the event specifics, such as; Event date, Event type, Number of attendees The system needs to be secure, user-friendly and capable of integrating with a payment gateway. Skills and experiences required: - Strong understanding of web development - Experience with form integration - Knowledge of payment gateway integration - Familiarity with user...

I'm seeking a skilled writer to draft an informative article about round conference tables. The piece will be aimed at a general audience, therefore, it's imperative that the content is engaging and easy to understand. Key Points: - The primary focus should be on educating readers about the unique benefits and features of round conference tables. - The article should highlight the distinctive qualities of round tables in comparison to other shapes, particularly emphasizing how these tables promote communication and collaboration, and their versatility in seating arrangements. - Article should be between 1,000 to 1,200 words - Article needs to contain 3 to 5 references to certain websites, which will be provided upon awarding of the project Ideal Ski...

...article about square conference tables. The article will serve as an informative resource for a general audience. Key points that should be covered in the article include: - Different designs and styles: The writer should explore the various design options available for square conference tables, discussing contemporary, minimalist, classic, or any other popular styles in the market. - Benefits and features: The article should highlight the practical and aesthetic benefits of choosing a square conference table over other shapes. This could include space-saving benefits, visual symmetry, or ease of communication between participants. - General information: The writer should provide a comprehensive overview of square conference tables, including their history, comm...

We are looking for an experienced Flutter developer to join our team and help finalize our ride-hailing application. The app is nearly complete, but we need assistance in implementing and refining our two-way communication system within the match-making component. The ideal candidate will have a strong background in Flutter, Bloc state management, and Node.js APIs. **Responsibilities:** - Debug and enhance the two-way communication functionality in our ride-hailing app. - Collaborate with our backend team to ensure seamless integration with Node.js APIs. - Implement and optimize Bloc state management for efficient state handling. - Ensure the app’s match-making system works reliably and efficiently. - Conduct thorough testing to identify and fix any bugs...

I am looking for a skilled programmer to develop an interactive chemistry experiment for me. You may code using JavaScript, HTML5 or using Python, so experience or proficiency in this language is cruci...moderate level of interactivity. This includes features such as adjusting quantities and temperatures. If a user pours something in a beaker, it should show the beaker full. If emptied, beaker is empty. - Vector images of lab equipments like Test tube, beaker, burner etc can be found online. Ideal Skills: - Proficiency in Python or JavaScript. You may use CreateJS libraries. If you are a programmer with a passion for chemistry, this is a great opportunity to combine your skills in programming and knowledge of chemistry. I'm excited to see the creative and educational experime...

Please Sign Up or Login to see details.

I'm searching for a talented designer capable of re-creating an existing brochure for my renting kitchens company. I have an example brochure to use as inspiration, but certain elements must be chang...changed to make it unique. These include: - Layout Modifications: Rearrange sections or resize elements to create a fresh look, avoiding a straight copy from the example. - Color Scheme Alterations: Implement different hues aligning with our branding. - Graphic Changes: Replace images or graphics with ones that better reflect our company identity. Ideal candidates should have a keen eye for design and a portfolio showcasing their proficiency in creating distinct and engaging brochures. Experience in interior design or kitchen related fields is a bonus. Please repl...

I'm in need of an experienced desk researcher based in UAE, to provide insights on the heavy machinery market in UAE. Key Research Areas: - Market Trends: Understanding th...Implications: Investigating the legal aspects and implications related to heavy machinery operations in the aforementioned countries. You should be adept at: - Conducting comprehensive desk research, utilizing industry reports, government websites, and trade publications. - Analyzing and synthesizing data to provide meaningful insights. - Understanding of the heavy machinery industry and its related fields such as insurance and legal aspects is highly preferred. Your research will be crucial in helping us make informed strategic decisions, so I'm looking for a diligent and detail-oriented profession...

I'm in need of an experienced desk researcher based in LATAM, to provide insights on the heavy machinery market in Brazil, Mexico, and Argentina. Key Research Areas: - Ma...Implications: Investigating the legal aspects and implications related to heavy machinery operations in the aforementioned countries. You should be adept at: - Conducting comprehensive desk research, utilizing industry reports, government websites, and trade publications. - Analyzing and synthesizing data to provide meaningful insights. - Understanding of the heavy machinery industry and its related fields such as insurance and legal aspects is highly preferred. Your research will be crucial in helping us make informed strategic decisions, so I'm looking for a diligent and detail-oriented profession...

...Google Play Console user who can help us with app upload. The ideal candidate should be familiar with the Google Play Console and have experience in uploading apps to the Google Play Store. The main responsibilities of this role include managing app listings, uploading Apps, and ensuring compliance with Google Play policies and guidelines. We are seeking someone who can efficiently navigate the Play Console interface, troubleshoot common issues, and optimize app metadata for better visibility. If you have a strong understanding of the app submission process and can deliver high-quality results, we would love to hear from you! Skills needed: - Google Play Console - App upload - APK management - Google Play policies - Troubleshooting - Responsible with ...

I'm in need of a skilled Web Application Developer to create a sales incentives system that will handle complex calculations and generate comprehensive reports. Ess...application should have a simple, intuitive interface for easy usage. - Reporting: The system should generate detailed reports on the sales incentives calculations. - Security: It's crucial that the application ensures the data and calculations are secure and protected. The ideal candidate should have: - Proven experience in developing web applications, particularly in sales or finance-related fields. - Strong mathematical and analytical skills. - Proficiency in programming languages suitable for web application development. - Good understanding of data security principles and best practices. - Excellent c...

I have an existing WordPress website built with Elementor Pro. I need to add one inner page and a contact page (popup). I have designs in PSD and Adobe Illustrator. I need an expert Elementor Pro developer who can start now and finish the task by tonight.

I'm looking for a freelancer to be the model for ultrasound demonstrations at a medical conference. These demonstrations will not focus on diagnosing a medical condition, but rather showcasing a particular company's medical device and technology. Ultrasound is a safe and non-invasive way to look into the body, it is used on children and pregnant people and had no xrays or magnetic fields. Ideal skills and experience: - Willingness to have ultrasound gel placed on the abdomen, neck and legs. - Willingness to have medically trained participants at the conference watch the images generated while you are scanned and discuss technical aspects of the ultrasound machine around you. - Willingness to be scanned by visitors to the conference booth, they will be under the supervisi...

In my project, I'm lookin...effectively Furthermore, I plan to utilize SOAPUI Open Source for automated testing of these messages. Your role will be essential in ensuring that the system works seamlessly with this tool. I will be expecting below: Create a framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for this role would include: - Proficient in ActiveMQ and JMS messaging - Previous experience in setting up asynchronous messaging systems - Familiar with SOAPUI and its capabilities for message testing - SQL developer for database queries and validations Please bid on this project if you're confident in your ...

Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database

I am seeking a team of experienced digital artists or animators with skills in Blender to create captivating anamorphic display content. This project aims to develop visually striking 3D animations that utilize anamorphic illusions to enhance public spaces, highlighting innovative design and cultural heritage through interactive digital art. Requirements: -Proficiency in Blender for 3D modeling and animation, with a strong portfolio showcasing relevant work. -Experience in scripting within Blender to automate tasks and enhance animation functionalities. -Knowledge of integrating Blender projects with other software for interactive displays. - Demonstrated ability to work on projects that combine art and technology, particularly in public or large-scale settings. ...

I'm in need of a desktop application that automates sperm analysis, leveraging the power of AI. This software will be used to create spermograms. Key Requirements: - Automation of Sperm Analysis: The sof...analysis. - Creation of Spermograms: The main purpose of the software is to create spermograms. This requires the software to be able to present the analysis in an organized and understandable way. Ideal Freelancer: - Proficient in AI and machine learning, particularly in the healthcare or biological fields. - Experience with developing desktop applications. - Previous work or knowledge of sperm analysis or similar medical diagnostics. This project is a unique opportunity for a freelancer with a strong background in AI and software development to contribut...

...who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment informa...

I am in search of a freelancer who can assist me in verifying the employment history and qualifications of potential candidates in Switzerland. This is crucial for me to ensure the accuracy of their past employment and to validate their qualifications. Key Respo...This is crucial for me to ensure the accuracy of their past employment and to validate their qualifications. Key Responsibilities: - Conducting thorough employment verification checks - Ensuring the accuracy of job titles and employment history - Verifying qualifications and past experiences - Providing detailed reports on your findings Ideal Skills: - Experience in HR, recruitment, or similar fields - Strong investigative and research skills - Excellent attention to detail - Understanding of Swiss employment laws and...

I am considering purchasing Ultimate POS software, but it lacks a crucial feature for managing individual product serial numbers. Although it includes an IMEI/Serial number feature, it only allows you to add the serial number at the po...units of the GoPro 12 model, I want to update my inventory by entering the serial number for each of the 5 units. This way, I can track which specific serial numbers are currently in stock. Additionally, I need the capability to search for products by their serial number when making a sale. The ideal candidate should have prior experience in customizing POS software, particularly in adding new fields, and should be proficient in inventory and supplier management system customization. Excellent communication and problem-solving skills are also high...

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

I need someone to extract the data from a PDF file and build it into a Word document. The purpose of this is to make the content editable. - The PDF is simple, with only text and no complicated layouts, images or tables. - I would like the extracted text in the Word document to have a specific formatting style applied where headings are large, words are small. Ideal candidates should have experience with PDF to Word conversion, and possess skills in editing and formatting. Being detail-oriented is a major plus. Please note that the extracted content must be accurate and the final Word document should maintain a professional finish. Do NOT deliver this as a simple export because I could easily do that. Run grammar checking for English (Australia)

I am looking for an expert in Python programming to assist me in the creation of a multi-timeframe indicator merge. The project entails the merger of the 4hr, 1hr, 15min, and 5 min timeframes while including specific indicators, namely Moving Average, Relative Strength Index (RSI), ADX, and Webslingers. To make informed bids, it's important to note the following: Ideal Skills & Experience: - Extensive knowledge in Python programming - Proven experience in financial analytics - Expertise in working with listed indicators Project Requirements: - Code the multiple timeframes using Python - Integrate the Moving Average, RSI, ADX, and Webslingers indicators - Generate the deliverable output as a CSV file Please feel free to inquire if you need more clarification or in...

I'm looking for a skilled developer to integrate two frontend files (HTML, CSS, JavaScript) into one single localhost. These files should display side by side and share a common footer. Key Requirements: - Integration of HTML, CSS and JavaScript files - Configure the files to display side by side - Implement a shared footer Ideal Skills: - Proficiency in HTML, CSS and JavaScript - Experience with frontend development and integration - Knowledge of localhost configuration and deployment Your understanding of frontend web development, integration, and configuration is crucial. A keen eye for detail and the ability to troubleshoot potential conflicts is needed to ensure a smooth integration process.

I'm looking for a talented individual who can a...inspection and create a comprehensive plan for the renovation. - Design the interior and exterior in a vintage style suitable for a hostel. - Focus on the redesign of the bedrooms and common areas. Ideal Skills and Experience: - Proven experience in architectural design and interior design, ideally with hostel or commercial property experience. - Proficiency in CAD software and other relevant tools. - Excellent communication skills and a keen eye for detail. - Ability to balance aesthetics with cost-effectiveness. Please provide examples of your previous work, particularly in the hostel or vintage design space, along with your bid. Your creativity and experience will be key in optimizing the space for a un...

PLEASE DO NOT SEND AI DESIGNS A 2D PLAN IS A MUST Seeking a talented interior designer to create a modern and stylish residential bedroom. Key Requirements: - Proficiency in residential interior design - Strong understanding of modern design principles - Experience in creating bedroom interiors The room will have the following 1. King size bed with 2 side tables 2. Large him/her walk-in closet 3. Desser table, for him/her 4. Tv unit – to be opposite to bed Please note 1. room height is 300cm, there is a concrete slab in the middle, the height from floor is 250cm 2. the room has 3 windows, any of these windows can be canceled to make a use of the space

I need a skilled developer to create an interactive form on top of a 272 color image. This form is specifically for data collection. Key Features: - The form should have fields for name and number. - For each of the 272 colors, there should be a slider or a quantity counter. The purpose of each slider or counter is to adjust the quantity of an item. - The form should have a "send" button, which will submit the filled form to an email address. Ideal Skills: - Proficient in web development, particularly in creating interactive interfaces. - Experience with integrating forms to email submission functionality. - Understanding of color sliders or quantity counter implementation. Please provide examples of similar interactive projects you have worked on in the past, a...

Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.

ONLY 1 COMPONENT IS NEEDED I'm in need of a skilled developer to help me design the layout of my office room using Nuxt & Vue. Key Requirements: - Implement a visual room skretch using Nuxt & Vue. This feature will help us in our daily work by quickly identifying which meeting rooms & places(tables) are occupied and which are available. Ideal Skills & Experience: - Strong experience in Nuxt & Vue is essential. - Experience with creating interactive and user-friendly features in web applications. This project requires creativity and an understanding of office space optimization. A successful implementation will result in a more efficient and productive workspace.

I'm in need of a talented label designer who can create a modern and minimalist wine label for my brand. "Clan McCauley Gin" Slogan: "Clan McCauley Gin: Crafted with heritage, enjoyed with friends." Logo: Design a logo that reflects the clan theme. You could incorporate imagery like a tartan pattern, a crest, or a stylized image of a family gathering. Bottle Design: Choose a bottle design that reflects the premium nature of the gin. A classic, heavy glass bottle with a simple label can be very effective. Bottle design for "The McCauley Cuvée" wine: Label Design: Since "Cuvée" implies a special blend, you could design a label that highlights this. Perhaps incorporate a blend ratio or m...

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data int...

I am on the lookout for a well-versed spirits consultant with a vast understanding and experience in liqueur production. My interest is not limited to any particular brand; rather, I am seeking a comprehensive understanding on a broader scale. What You Are Expected To Deliver: - Compelling insights into overall production process of various liqueurs from a general perspective. - Suggestions, advice, or methods for improving production efficiency without compromising quality. As a qualified applicant, you should: - Hold a degree or certification in food sciences, chemistry, or related fields. - Have solid experience in the spirits industry, particularly in the production of liqueurs. - Show an understanding of scaling production processes. - Demonstrate adeptness at identif...

I am seeking a full stack PHP developer to assist me with my project. I'm looking for a PHP expert who can aid in the development of a web application, website, or mobile app. You should be proficient in both front-end and back-end development, capable of crafting user-friendly interfaces and integrating complex functionalities. Your role will involve: - Understanding project requirements and delivering high-quality work - Developing secure, efficient, and scalable code - Implementing user authentication, integrating databases, and possibly setting up payment processing systems - Ensuring timely and reliable completion of the project If you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applicati...