Sql combine columns from two tables jobs

I'm in need of an experienced UI/UX designer to review, customize, and improve my Shopify store's existing theme, as well as the app using in Shopify that sells phone cases and accessories. The primary focus is on enhancing the user experience to drive increased conversion rates. Key ...experience in UI/UX design, particularly for e-commerce platforms - A clear understanding of user experience best practices and how they relate to increasing conversion rates - Strong communication skills and a proactive approach to suggesting improvements I'm looking for a proactive, creative and experienced freelancer who can take my store to the next level. Your approach to the project should combine a keen eye for design with a data-driven understanding of how UX improvements can...

I am looking for a Video editor that can perform the following tasks - - Remove green screen and replace it with image background - Combine multiple footage - HD (1080) Render

...proficient Python coder who can develop a program that effectively reads numerous reviews and generates a concise summary, encapsulating the main points in 300 words in multiple bullet points. Key Functions: - Extract data from a relational database via SQL queries. - The ability to process and analyze reviews from different platforms such as blogs, social media, and online stores. - Generate a coherent 300-word summary from a multitude of reviews. Required Skills and Experience: - Expert level understanding of Python programming. - Knowledge and experience in SQL querying is a necessity. - Experience with Natural Language Processing for summarization. - Familiarity in dealing with relational databases. - Prior experience with text summarization or...

I'm in need of a skilled freelancer with proficient online research and data entry skills. Responsibilities: - Conduct online research to collect necessary data - Expertise in entering numerical data precisely - Compile, verify accuracy and organize the information into a Excel spreadsheet Desired skills/experience: - Attention to detail - Experience in data entry - Excellent knowledge of MS Excel - Strong ability in online researching

The target of this project is the organization of content tables, figures, and tables. In addition, rewriting and editing the manuscript should be done to improve the information and language. rAs a plus, replying to the suggestions and remarks that will be made.

I'm looking for an experienced freelancer to convert a Google document into a Word document. The Google document may contain a variety of elements such as font styles and sizes, bulleted or numbered lists, and tables. Ideal Skills and Experience: - Proficiency in Google Docs and Microsoft Word - Experience in document formatting and conversion - Attention to detail in maintaining the original document's formatting I anticipate a quick turnaround for this project.

Simple task, I need the background removing from this logo so it can be used online.

I'm in need of an expert to set up SQL Server 2019 on a Windows-based virtual machine. The system will be used to support website and desktop applications. Key Responsibilities: - Configuration of SQL Server 2019 on a Windows virtual machine - Ensuring secure and optimal performance of the system - Testing the setup to confirm seamless connectivity with website and desktop apps Ideal Skills: - Extensive experience in managing SQL Server 2019 - Expertise in Windows OS and virtual machines - Should have strong troubleshooting skills on SQL server - Familiarity with website and desktop app integrations.

Excited to work with an experienced ASP.Net webforms developer, who will bring their skills to facilitate the Database integration aspect of our project. Key Responsibilities: - Integrate SQL Server with our existing ASP.Net project. - Create smooth and efficient functionality. - Ensure system robustness and efficiency. Skills and Experience: - Strong proficiency with ASP.Net Webforms. - Knowledge and hands-on experience working with SQL Server. - Excellent troubleshooting capabilities. It is not necessary for this project to migrate data from an existing database to SQL Server. However, the capability to do so may be beneficial in the future. If you are an experienced developer with the aforementioned skills, I would love to have you on board for this p...

I'm looking for a seasoned copywriter and wordpress designer with strong experience in Elementor Pro, WP Funnels Pro, WooCommerce, and AI image design tools, notably Canva, and dale. The major task is to develop 50 services funnels with the prime goal of increasing sales. Key Respo...Experience: - Proven expertise in creating high-converting sales funnels - Strong knowledge of AI image design tools preferably Canva - Proficiency in Elementor Pro, WP Funnels Pro and WooCommerce - Stellar copywriting skills, particularly with sales copy In essence, I'm after a copywriter who can combine strong visual design with compelling copy to drive sales. If you can work with these specified tools and have a track record of increasing sales through effective funnel creation, I'...

Following are the requirements of task to be fulfilled. 1- Task is to visit the Gottingen physically and Take 5 to 6 geotagged photos of with name board captured and from outside the building. 2- Get the verification form filled, signed and stamped by the HR and also stamp the certificate. 3- Get the details of verifier, Name, Designation, Department and Contact. 4- In case of refusal to fill form, take the written refusal with stamp or sign as a proof. 5- If companydoes not found on given address than take the 7 to 8 geotagged photos of exact address with right left name boards photos and make a small few seconds video of address . Also get the details of any nearby business ( Name of person, Business name and Contact

I need a freelancer who can effectively convert a PDF file into a Word document. The purpose is to edit the document's content while retaining its original formatting. This should be an easy job, as the PDF contains simple text and no graphics, tables, or charts. In addition, it's crucial the Word document matches the exact formatting of the PDF. This job is ideal for freelancers with skills and experience in PDF conversion, document formatting, and text editing in Word. Accuracy and attention to detail are central to this project's success.

I am looking to streamline my excel data entry process. Needs centralized on the automation of numerical data entry in my Excel spreadsheets. Key requirements: - Automate simple data entry into few columns. - Experience with Excel data entry automation required. - Should have good knowledge of Excel functionalities and automations. - Ability to handle numerical data efficiently. Experience in handling simple data entry (few columns) and automating the same would be ideal for this job. Reach out if you need more information and looking forward to your expert assistance in this process improvement.

We are currently advancing two web-based projects, each with potential for future expansion depending on client satisfaction and ongoing evaluations. Project 1: Integration and API Development This project involves creating a synchronized customer table accessible via both web and mobile applications, and developing and integrating APIs. We also need to enable the functionality to preview and download existing quotes via the web and mobile applications. Additionally, assisting the client in installing the latest version on their local host to facilitate their participation in the testing process. Project 2: Software Enhancement and Bug Resolution Our second project is a comprehensive web-based software developed using HTML, Bootstrap, PHP, Laravel, and MySQL. We are not aiming to ...

...quality Executes work efficiently and meets agreed on deadlines Completes most development activities independently Requirements Core Requirements: Strong background in data warehousing concepts, ETL development, data modeling, metadata management and data quality Strong knowledge of SQL running on SQL Server, MySQL, and Snowflake including but not limited to: extensive experience working with complex stored procedures, table definitions, and a proven track-record of performance optimizations and troubleshooting of SQL logic. Proficient at C# running on .NET Core and/or other similar .NET frameworks including but not limited to: writing Unit Tests and implementing algorithms and data structures Strong hands on experience in Microservices, RESTful webservices devel...

Seeking a highly skilled Tikz and Latex programmer to create a variety of graphics and tables for my research paper. Types of Graphics: The project will require the creation of: - Diagrams - Plots - 3D Representations - Tables Role of Graphics: The graphics and tables produced will serve to: - Illustrictate complex concepts - Visualize data - Compare and contrast research results Required Skills: The ideal candidate for this project should be proficient in: - Tikz - Latex Your contribution will play a crucial role in enhancing the visual appeal and readability of my research paper. Prior experience in similar projects would be advantageous. Let's make science more understandable and engaging!

Assist in 60 dropshipping items from Aliexpress to Ebay Australia. Thanks Andy

I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.

I need a freelancer to convert a PDF file into a Word document while preserving its basic text formatting. Additionally, I would like the freelancer to create a table of contents in the Word document. The ideal candidate should be proficient in: - PDF to Word conversion - Basic text formatting in Word - Creating tables of contents in Word It is important that the freelancer maintains the integrity of the document's formatting during the conversion process.

I am currently searching for an adept graphic designer to create a combination logo for my busi...impression, reflecting the comforting environment that we provide to our clientele. Ideal skills and experience: - You have a strong understanding of logo design, preferably with prior experience in combination logos. - You have designed for the beauty/medspa industry or similar before, and understand the importance of visual representation in these types of businesses. - You can creatively combine text and imagery to build an engaging, multifunctional logo. - Your work shows your ability to translate client preferences into aesthetically pleasing designs. This project is a fantastic opportunity for graphic designers who flourish in translating a business's ethos directly into ...

I'm looking to create an application using NoCode developmen...credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I'm looking for a freelancer who is skilled with NoCode tools, specifically Bubble and FlutterFlow, has implemented email/password user authentication before, and has experience with SQL Server database management. Please contact to get more deta...

I'm seeking a talented graphic designer to create a vector image of a perfume bottle. The design needs to be vintage-themed, capturing the essence of the original image.. The final design must also incorporate the brand name. The ideal freelancer will have: - Proficien...ideal freelancer will have: - Proficiency in vector image creation - Expertise in design Attention to detail is crucial for this project, in order to maintain the accuracy and beauty of the original design while adding the necessary branding elements. This graphic will be used on product packaging, so quality and impact are vital. The file is required in an AI file and layered PSD file. I need two versions, one like a line drawing version and the other a more of a block version with some details. I have att...

I'm seeking a talented graphic designer to create a vector image of a perfume bottle. The design needs to be vintage-themed, capturing the essence of the original image.. The final design must also incorporate the brand name. The ideal freelancer will have: - Proficiency in vector image creation - Expertise in design Attention to detail is crucial for this project, in order to maintain the accuracy and beauty of the original design while adding the necessary branding elements. This graphic will be used on product packaging, so quality and impact are vital. The file is required in an AI file and layered PSD file.

I want to create a quiz that can be embedded into a website page builder using their embed feature. The quiz should be manageable from my dashboard, the script will be on it's own domain. Key Aspects: - Creation: The plugin should enable the user to create quizzes. Please advise on the best quiz type to use. - Embedding: The plugin should allow for easy embedding into website pages or blog posts. Being able to place the quiz in a sidebar widget would be a bonus. - Interaction: I am open to different ways for users to interact with the quiz, either by clicking on options, typing answers, or selecting from dropdown menus. Your insights on the most user-friendly option are welcome. - Management: The plugin should provide an interface to manage the quizzes. Ideal Skills...

I'm in search of a skilled Shopify / wordpress developer to expertly migrate two e-commerce websites into one platform while maintaining separate branding on individual storefronts. Migrate to Shopify or another cloud-based platform like Webflow. Not interested in migrating into WooCommerce. The new website should share one backend with a shared inventory, but the two should cater to two different websites each with - own branding - own URL - own mailing list (mail chimp or native to platform) Key tasks include: - Migrating existing sites built on Shopify and Woocommerce into one site - either Shopify or Webflow - Implementing a shared backend inventory across the two storefronts, supplemented by individual branding and mailing lists. - We want option to...

I require a professional freelancer with expertise in graphic design to create a custom label for my candles. The desig...design should reflect a modern aesthetic. The key elements to include in the design are: - A unique logo that effectively represents the brand - Detailed product information - Artistic illustrations that enhance the overall aesthetics of the label - An inspiring affirmation to engage the end customer The ideal freelancer for this task will have a strong portfolio showcasing their ability to combine these elements into a coherent and visually compelling label design. A background in packaging design or prior experience in creating candle labels will be considered a major advantage. A keen attention to detail and a creative flair are essential for success in thi...

I'm in need of a professional and experienced C++ developer to convert my existing Matlab code to C++, with an advanced level of optimization. The primary goal of this conversion is to ensure that the C++ code runs seamlessly on a different platform.

Description: I am seeking an e...Information: The ability to add custom fields to user profiles is essential. These fields should include but are not limited to personal information, investment history, contact details, etc. Backend Management: The system should be manageable entirely from the WordPress admin panel, with capabilities to add, edit, and view investor profiles. Privacy and Security: Ensure that the data is securely stored and that privacy measures are properly implemented since this information is sensitive. Experience with Advanced Custom Fields (ACF), Admin Columns, or similar plugins is highly preferred. The ideal candidate will have prior experience in developing custom user management systems on WordPress and should provide examples of similar projects the...

I require an experienced drafter to create comprehensive workshop fabrication drawings for structural steel components (specifically beams and columns). These drawings need to be in PDF format. While no specific standard or code was requested by me, it would be beneficial for potential candidates to have a strong knowledge of structural steel design codes. Proficiency in tekla, advance steel or similar software is a minimum requirement for this project. A set of drawings for review will be required prior to the release of the milestone payment, once the engineer approves the drawings for fabrication the payment will be processed via freelancer. I have architectural and engineering plans reflecting all critical specifications

I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.

Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.

I want you create similar logo , to the attached one . More modern and clean Design: Combine the runes Fehu and Sowilo in a stylized lighthouse design. could be designed so that the structure itself takes the shape of the Fehu rune, while the light of the lhouse represents the Sowilo rune. • Colors: Use blue and gray tones for the lighthouse to symbolize professionalism and trust, with a bold yellow or gold for the light, radiating warmth and success. • Font: Choose a modern, clear font for the company name, placed below or beside the company

... Key requirements include: - Proficiency in product sourcing: Prior experience Listening ads from Alibaba to eBay and selling them with probably in sourcing electronics, particularly smartphones and watches, from platforms like Alibaba or AliExpress with high preferablity. - Strong marketing and sales skills: The ideal candidate should have a solid track record in reselling products online, especially electronics, and should be able to create effective marketing strategies to drive sales. - Previous experience in reselling: And the money is going to come from the project itself once they are comfortable then we will be able to pay you ongoingHaving successfully resold smartphones and watches from Alibaba, AliExpress, or similar platforms to eBay or other sto...

...all database tables. This project will involve implementing advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a single, generic controller that can dynamically handle all tables within the database. This approach requires sophisticated coding to manage CRUD operations generically across all tables. 3. Metadata-Driven Architecture: The dat...

For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the project further.

Being in the midst of a Shopify app project, I am seeking a competent developer to provide a clear-cut report on whether our App we hired a tech to do is actually an app or just a Laravel website and if it can actually be submitted as a Shopify app, or if it ...finishing and subnmitting at the very least cost and effort a actual Shopify app out of our current project - it is in submission stages but WEB HOOK issue is the error.- review and understand the installation and webhook issues. - Maintaining the approval feature from our Laravel website. The chosen candidate needs prior experience with Laravel websites, Shopify apps, and general web development So, if you're an experienced developer with the ability to decipher projects and turn them into something, I would like to...

I'm seeking individuals who have experienced significant results using GLP-1 medications like Ozempic, Mounjaro, or similar drugs. Interview you for your personal experience with GLP-1 medications. Highlight any health changes. Must have used GLP-1 medications. Must provide evidence of medical prescriptions.

For this project, I am seeking a creative visionary to design an expo that will effectively showcase two schools as one. The expo design will need to: - Emphasize a theme of collaboration between the two institutions - Enhance brand awareness for both schools - Incorporate both schools' logos To achieve this, you will create two posters and one backdrop. You should be able to seamlessly merge the distinct identities of two schools into a single, coordinated visual layout. Preferred color scheme: - The preschool requires multiple colors. - For the elementary, we would like you to use the colors Blue and Red. Ideal Skills and Experience: - Proven experience in designing for expos or similar events - Exemplary visual design skills - Ability to work with ...

I need a talented freelancer to help me with a special project - removing a person from wedding photos. The wedding party is medium-sized (11-25 people) and I need 9 photos edited. It is important that the project gets done as soon as practicable. Ideally, I would like to see a portfolio of past similar work completed successfully. Attention to detail and a high degree of accuracy are a must in order to produce the best results. If you think you have what it takes to complete this project for me, I look forward to hearing from you soon! Thank you!

I require an expert proficient in Python, SQL, and Java to work on a Codility assessment. The assessment will be conducted at an intermediate level and will be inclusive of various tasks that I will be solving in the language of the question. Key Requirements: - Comprehensive Knowledge in Python, SQL, and Java - Proficiency in tackling Codility assessments - Understanding of the assessment's specific concepts and frameworks Remember to adhere to Codility's test format and code-writing guidelines. Your completion and success of this project will greatly depend on your ability to grasp and execute these particularities.

Continuation SEO for Second Month

...Traffic noise mapping = weight age (40%) 4) Modelling of noise barrier = weight age (10%) Project Details: Project Description: We are seeking a skilled freelancer to assist with a project that involves in-depth research and document analysis. The project entails working on specific tasks outlined in the provided files and research documents. Project Phases: Step 1: The project will be divided into two steps. The first progress update is expected within 15 hours of commencement. This initial milestone should aim to have 80% of the work completed, as we are working towards a tight deadline. Requirements: Proficiency in research and document analysis. Ability to meet tight deadlines. Strong communication skills for progress updates. Deliverables: Progress update within 15 hours w...

I need assistance to solve three coding tasks using Python, Java, and SQL. The challenge involves - Analytical problem-solving - Implementing quality checks - Code compilation The challenges require proficient skills in the aforementioned languages, while also ensuring code efficiency. Prior experience in problem-solving and understanding how to efficiently check and maintain the quality of code is a big plus.

Skills -core php, laravel, Codeigniter my sql database Min 1 to 5 year experience location - Mohali,Punjab, India

...individual components within the diptube assembly. This will help visualize how everything fits together and identify any potential issues with spacing or accessibility. Mechanical Drawings: Produce detailed drawings of each component, highlighting dimensions, tolerances, and material specifications. These drawings will serve as the basis for creating the 3D model in AutoCAD. Assembly Drawings: Combine the individual component drawings into assembly drawings that show how they come together to form the complete diptube structure. Prototype Blueprints: Translate the design into preliminary blueprints using AutoCAD. These blueprints should provide a clear representation of the diptube design, including all necessary views (e.g., top, side, front) and dimensions. Annotations: In...

I'm looking for someone who has very good experience in Laravel's real world situation. What Queue drivers are available in Laravel? Will ignore any replie...drivers are available in Laravel? Will ignore any replies without answering to the above my question. Here is my problem now. We are using Laravel project and it's running on production. It's using Queue heavily and queue driver is database now. We are getting following issue. SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (Connection: mysql, SQL: select * from `jobs` where `id` = 111111 limit 1 for update) Let me know how to fix this then I will hire you immediately and you can be employed in our project. Please don't waste my time if you don'...

I'm in need of assistance with Codility assessments, specifically focusing on intermediate-level problem-solving tasks. Your work should encompass: - Expertise in SQL or Python. Familiarity with both languages is advantageous. - Proficiency in algorithmic programming, capable of thinking strategically to solve intermediate-level problems. - Ability to assist in solving three different task types in Codility, including: 1. Time complexity problems 2. Sorting and searching problems 3. Counting elements problems Ideal candidates would have experience preparing or mentoring for codility assessments and a strong background in programming. Your intricate knowledge of problem-solving within the realms of algorithmic programming would be highly beneficial. A methodical appro...

I'm looking for a skilled web developer who can create a ...top-notch website for my pizzeria, Napoletana. The website should ideally be a reflection of our brand, incorporating a red and white color scheme into the design. Key Features to Include: - An efficient online ordering system for a seamless customer experience - A section for our menu, complete with prices and detailed descriptions - A straightforward reservation system for customers to book tables with ease In terms of visuals, we have images that we'd like to use for the website. Hence, an ability to incorporate these into the design tastefully is crucial. The ideal candidate should have experience in building restaurant websites and an understanding of user interface to provide an easy-to-navigate platfor...

I have a Canva design, a domain, and hosting in place. I need an experienced WordPress professional to bring this design to life on my website with some key updates: - Apply Layout Modifications: I need the design layout reconfigured to better suit my vision. With expert knowledge of WordPress's customization options, you can tweak the layout to make it more engaging and fitting for my brand. - Content Updates: The project involves adding or removing certain sections on the website as per requirement. You should have an eye for detail to ensure these changes do not affect the overall harmony of the design. Your experience in translating designs to WordPress websites will be key to the success of this project. You should also be comfortable in guiding me to maintain the site post-de...

I'm looking for an experienced CAD designer to help convert my 2D PDF into a fully interactive 3D plan using AutoCAD. The reproduction should have a medium level of details to capture the critical components of the plan but don't necessarily have to be high detailed with textures. Ideal Skills: - Proficiency in AutoCAD - Experience in converting 2D blueprints to 3D models - Ability to make the 3D Model interactive Experience in creating interactive 3D models is crucial for the successful completion of this task, as the final output will need to respond interactively to the user's prompts. Expertise in AutoCAD software will also be important to accurately and efficiently convert our 2D PDF into 3D.