How to retrieve data from two tables with one sql statement jobs

...PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. To qualify you must be full stack and work...

I have a bulk of digital files that need to be accurately transcribed into a digital format. The files are all in English, so proficiency in English is necessary for this project. Ideal skills and experience include: - Proficient in English - Fast and accurate typing skills - Experience with data entry

I'm in need of a professional who can perfectly format my 100-page Word document. The document requires: - Adjusting the page layout - Ensuring consistent and appealing font styles and sizes are used throughout - Ensuring all tables are well-formatted and visually appealing In your application, please focus on showcasing your experience in Word document formatting. I don't need any graphics or images inserted into the document, just a clean and consistent format.

I'm looking for a Photoshop expert to help me with editing two photos for personal use. I need the following done: - Add text in the center of each photo - Remove unnecessary objects from the photos The skills required for this job include: - Proficiency in Photoshop - Attention to detail - Experience with photo editing - Creative thinking to make text additions look natural Please note that the purpose of these edits is for personal use so they need to be visually appealing and well executed. It will be necessary to ensure that the text additions blend seamlessly with the rest of the image.

I am seeking a creative and experienced graphic designer to craft a vibrant, standard size (3.5 x 2 inches), two-sided visiting card. The design of this card should highlight my business, convey vital information, and tell my brand story in a compelling manner. Key requirements include: - The inclusion of my name and contact information. - Use of logo and tagline in the design. - Bright and vibrant color scheme to align with the energetic aspects of my brand. Ideal candidates should have proficiency in .cdr file format and previous experience in business card design. Your bid should include a brief portfolio showcasing past works in business card design.

One Month SEO services for the website

I require a freelancer skilled in survey design and impactful visual content to make changes to an existing electronic survey I have in Survey Monkey. Here is some insight into the specific tasks you'll be undertaking: - Update and enhance the current survey: This involves infusing fresh content by updating existing questions, introducing new questions, and replacing the current graphics. - Create an entirely new survey: This will include a mix of existing and new questions, along with logos and product images. The goal of this survey will be to gather customer feedback, so creating questions that retrieve valuable customer insights will be essential. - Build a survey flow and link answers for follow up automated EDMS and other forms of communica...

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Deliver...

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription

I'm looking for a ticket reservation system to help manage vehicle bookings at my car repair workshop. Key Features: - Customers should be able to specify the type of repairs they need by describing it in a text field. - The system should capture this information, along with the basic details like their name, contact information, and the time they'd like to come in for the repair. Skills and Experience Required: - Experience in building ticketing systems, ideally for a service-oriented business like a workshop or a customer support center. - Familiarity with implementing text fields for user input. - Good understanding of user experience and interface design for a seamless customer journey. - Knowledge in database management to store...

I need a professional to prepare my income statement and balance sheet according to IFRS standards. My records are ready, and I only require a summary-level of detail. Ideal skills and experience include: - Proficiency in IFRS (International Financial Reporting Standards) - Proven track record in preparing financial statements, especially income statements and balance sheets - Detail-oriented and able to work with a high level of accuracy - Good communication skills to clarify any details for a summary-level reporting. This is a one-time project, but if successful, there may be more in the future.

I require an experienced accountant to prepare a set of financial documents for my company. Last 2 year Audited Financial statements for the previous 2 fiscal year-ends: Income Statement, Balance Sheet, Cash Flow Statement Interim Financial Statements (Balance Sheet, P&L, Cash Flow Statement) Financial statements for the most recent interim period: Income Statement, Balance Sheet, Cash Flow Statement Merchant Processing Statement

I'm in need of a skilled website designer and content creator to assist with the creation of a detailed, interactive product information guide for our exciting Pontoon Boat company and high-performance aluminum bass boat division. Key Requirements: - The guide will be in the form of a website with interactive features, allowing users to retrieve model information quickly on an iPhone or android phone. - The website must include detailed model specifications, covering dimensions and weight, engine specifications, seating capacity, fuel capacity, as well as standard and optional features - The guide should be comprehensive, showcasing the brand, series, and individual models with specifications, standards, and options Key Skills: - Website des...

I want to design a car wash, and I want to import the goods from China, but I do not know what is the method, the best quality, and the method of communication. I want boxes for electric tanks that are made of carbon fiber, I want washing materials, I want water pumps, vacuum cleaners, all cleaning tools, and some other things. Ideal Skills: - Proficiency in Chinese - Experience with online dispute resolution - Strong communication skills - Understanding of international commerce and refund procedures

...have an apartment that I plan to host on Airbnb and require detailed, high-resolution photos of various furniture including chairs, tables, and sofas. This is a 1-2 rooms apartment, and it's essential to have photographs of every area, including the kitchen and bathroom. • Proven photography experience, especially in furniture photography • Ability to create attractive shots that capture the details • Experience in editing photos will be advantageous. • Responsibility to care for the furniture while working around it. • Proficient in effectively utilizing lighting to accentuate the aesthetics of the furniture. I want the potential Airbnb guests to see the beauty and comfort of my place through your lens....

I'm looking to leverage Azure document intelligence prebuilt models and train models to extract data from a variety of tax and financial documents. The extracted data needs to be exported into a Google spreadsheet. Additionally, I need an interface for users to easily upload these documents. Key Requirements: - Extract data from various financial documents: primarily focusing on Expense reports, W-2 forms, credit card statements, 1099s, and annuities. - Extract specific data from credit card statements such as Transaction amounts, Merchant names, Transaction dates, and also the ability to convert currency and combine rows. - Extract specific data from bank statements like Account balance...

...switching from autonomous to manual driving. 【2　Technology Description】 Information processing technology that detects a request to switch from autonomous to manual driving during vehicle automation, and if such a request occurs, explains part of the reason for the request to the vehicle's driver. Please search for this technology. 【3. Reference Technology】 ・Example: If a request to switch to manual driving occurs during autonomous driving, the driver's statement is captured, and based on that statement, part of the reason for the request is explained to the driver. ・Example: Memorizing the correlation between the driver's statement and part of the reason for the request. ・Example: If th...

PDF File converted to MS WORD File more than 300 pages Need ASAP

I'm searching for a skilled individual who can help me scrape data from a website. The data I'm interested in is text content and tables, specifically contact information. Ideal Skills: - Proficiency in web scraping tools - Strong experience with scraping text content and tables - Expertise in extracting specific information - Familiarity with structured data formats The contact information on the website is in a structured format. Your ability to navigate this and provide me with a clean, organized dataset will be crucial. Looking forward to collaborating with a detail-oriented and reliable professional. Attached is a sample format. The site is: Final file must contain all records for all sch...

As the project owner, I'm looking to transform an image file of a 2D floor plan into a to-scale outline floor plan. For this project, the digitized floor plan should include room measurements. While I didn't specify a preferred software, utilizing a program adept at architectural design, such as AutoCAD or SketchUp, would be beneficial. The ideal freelancer would possess: - Proficiency in architectural drafting software - Experience transforming image files into digital floor plans - Attention to detail, specifically regarding accurate room measurements.

...searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can off...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you available?

Need to copy a powerpoint presentation from a video all the slides theres about 30-40 slides some just images and some some text

...need a skilled Wordpress expert to address a migration issue I'm facing with my website. Here's what I need: - **Migration Issue:** The problem I'm experiencing is related to theme and plugin compatibility following the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep unders...

I'm looking for a skilled professional to create a Web Assembly prototype, , using a small Delphi application that primarily showcases an interactive user interface. The aim is to target the prototype for web browsers. Key Requirements: - Creation of a Web Assembly prototype utilizing a Delphi application. - Focus on showcasing a simple interactive user interface The Prototype: - The user interface for the prototype is envisioned to be simple, consisting of basic elements. - The primary focus should be on the seamless integration of the Delphi application's functionality into a web browser environment.

I need a data studio expert to create a comprehensive report for my Google Ads and meta data. The report should focus on: - Click-through rate - Conversion rate - Cost per click - Conversions per key word The report should cover the last 30 days. I prefer a report that represents data in tables and numbers rather than through charts and graphs. Skills required: - Proficiency in Google Data Studio - Strong understanding of Google Ads and meta data - Ability to work with large data sets and visualize information effectively in tables and numbers - Strong analytical skills to draw insights from the data presented

I'm seeking a skilled and versatile bookkeeper to manage my accounts in QuickBooks. Key Responsibilities Include: - Daily entry of transactions - Financial statement preparation - Tax planning and filing Ideal Qualifications: - Proficiency in QuickBooks - Experience in managing both accounts payable and receivable - Strong understanding of tax planning - Excellent attention to detail - Previous experience working with a diverse range of transactions I value clear communication and a proactive approach to managing my finances. The role may be expanded in the future if the right candidate demonstrates a keen eye for financial strategy.

...freelancer who can take the annual billing data from my personal business and create a professional, neat invoice from it. Key Details: - Final Format: The final invoice should be in PDF format. - Summary: I'd like the invoice to include a summary of the total income generated over the year. The summary should be kept simple and straightforward with a total sum, without the need for categorization or a monthly breakdown. Ideal Skills: - Strong attention to detail: The invoice should be well laid out and error-free. - Graphic Design: Experience in adding logos and making documents look professional is a plus. - Familiarity with accounting and invoicing: Some knowledge of these areas will be beneficial for understanding the contex...

I’m looking for an innovative graphic designer to create a captivating postcard for my real estate investment company. The design should be aimed at generating leads for buying houses and establishing credibility. Key details to include: - Call to action: Call or Text for free no-obligation cash offer - Contact Information - Benefits of Selling to an Investor. The design should also be centered around promoting our unique selling proposition - 'We Buy Houses - Sell As-Is For Cash.' The aim is to make this stand out and appeal to potential customers. To enhance trust and credibility, testimonials from previous clients should also be creatively incorporated into the design. Ideal skills and Experience: - Proven exp...

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. E...

I am seeking a vibrant, innovative brand strategist for a budding brand. The ideal candidate will understand how to speak to professionals in the 25-40 range successfully, recognizing their needs, tastes, and aspirations. Tasks: - Development of a brand strategy from scratch encompassing all key factors: the vision, mission, personality and the positioning statement. - In-depth competitive analysis to understand stand-out strategies in the current market. - Collaborative creation of a novel, targeted marketing plan. The suitable candidate should have: - Able track record of successful brand creation from zero. - Proficient understanding of marketing towards a professional demographic. - Sound knowledge of competitive analysis techniques.

...software specifically designed with the features of project management, budget tracking, and document sharing. The primary function of this software will be to drive project efficiency by keeping all project details organized, deliver real-time budget oversight, and facilitate instant file exchanges. This tool is intended for use by my project managers and office administrators. Consequently, the ideal freelancer for this task should possess a strong proficiency in cloud-based software development, particularly those intended for construction project management. Your experience should also extend to designing user-friendly interfaces that cater to the needs of project management and administrative professionals. Web Application A cloud-based platform designe...

I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in ...

I will help you getting a job on linkedin through the whole month i dily apply for a job on linkedin for you inshallah we will achieve this...

I'm looking for an expert to take the text from my Word document and incorporate it into my Canva slides. The slides are for a presentation, so it's crucial that the information is presented clearly and with a professional touch. Key Tasks: - Transferring text from a Word document to Canva slides - Ensuring all text is appropriately sized, formatted and positioned within each slide - Adapting the text to fit the existing layout and design of the slides - Keeping the information clear and engaging for a presentation audience Ideal Skills and Experience: - Proficiency with Canva - Excellent attention to detail - Prior experience with creating or modifying presentations - Ability to adapt existing layouts to...

I'm seeking an Airtable expert to assist me with a number of tasks, including data entry and organization, building custom workflows, and creating advanced formulas. Ideal candidates should have: - Previous experience working with Airtable, including data entry and organization, workflow creation, and complex formula design - A strong understanding of how to make the most of the tool, including its integrations and automations Please note that while my exact requirements in terms of the number of tables and views in my Airtable base, as well as specific integrations I need, have not been stated, I expect the freelancer to be able to adapt to my needs and work in an agile manner.

Data Specialist: The Data Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with di...

...tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system seamles...

a) investment cost analysis ) b) p&l c) Revenue analysis and d) Analysis of operating expenses

1) investment cost analysis (fixed) b) p&l c) Revenue analysis (3 years minimum) d) Analysis of operating expenses

...Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and...

To woRk collectivialey to create with leadership an engaged and positive work enviroment lour peers innovation | research understand stewards budget communcatioN scheduling & planning Provide a positive an work experienflanning. events, acuare Uncationg, tenteR recognition a astargning opportunity,

...India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-based independen...

Crear una web para venta de propiedades, que tenga opcion de buscador y que permita ingresar propiedades con fotografias e informacion. Se proveera de servidor donde dejar la web, ademas ya se dispone de dominio en chile. Se debera dejar la web creada en el servidor y enlazado a dominio. La web debe ser similar a esta: Gracias,

- Size: 36" high by 48" wide - Plotting and vector cut line - 2 files one with dimensions displayed other with artwork and cut contour lines. - Should be able to change color of each element in file with just click and fill. - Text if there should be editable (words, font and color)

I need someone who knows about monorepo and angular , the application was in angular 10 and I transferred it to angular 17 (dependencies, code, etc.) now it seems to compile but it throws an error NG0908 .I just need them to make me work (run well in ngserve). Please write ragnar to see you read the post.

have anyone can help me to install the Laravel system which buy from themeforest, thanks i will provide the domain and also the login of the hosting, thanks

I have an existing Laravel-based ecommerce application that requires a series of modifications and additions. Key Tasks: - **New Tables & Conditions**: I'm looking to add several new tables and conditions to the application. Skills & Experience: - **Laravel Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience with ecommerce applications. The ideal candidate should be highly proficient in Laravel framework and comfortable creating new tables and conditions within the application. - **Database Management**: A solid grasp on database management is crucial to successfully add and integrate these new tables. Experience with MySQL or other relational databases is desirable.

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription