Small sql query jobs

...business. The name of my brand is 'Vividgrove' and I'm seeking out a design that exudes a modern appearance. Logo Requirements: - Color: I am envisioning a palette that extends a feel of modernity. - Visual Elements: A clear preference is set on geometric shapes and clean lines, but abstract forms are also welcome when they align with the modernist theme. - Style: Despite skipping the style query, a nonpareil blend of sleekness and minimalism in the logo is contemplated. Ideal Skills: - A strong background in graphic design with a distinctive flair for modern aesthetics - Proficiency in design software such as Adobe Illustrator, Photoshop, or InDesign - A depth understanding of color theory, balanced composition, and current logo trends Experience: A portfolio...

I'm looking for Java programmer who can correct web service definitions in existing project that use JAXWS 2.1.7. WebService has added new methods. We are implementing those methods with new wsdl definition file and subsistent * and * files There is an error at () call. error message: : : 4 counts of IllegalAnnotationExceptions XmlSchemaType annotation is not allowed on this kind of property. this problem is related to the following location: at @(namespace=, type=class $DEFAULT, name=dateTime) jar runs inside Domino server

...lookout for an efficient data entry expert who can not only help me with typing documents but also extract data from various websites. The candidate would then be required to systematically organise this data into spreadsheets. - Task Description: - Typing documents - Data extraction from websites - Data entry into spreadsheets Please note, the data volume for this undertaking is small, specifically less than 100 entries. - Tools Requirement: Your familiarity with Microsoft Office Suite is a must since it is our preferred software to perform these tasks. Ideally, I'd like someone with good typing speed, accuracy, and keen attention to detail. Experience in carrying out similar projects would be appreciated. Your thoroughness would help make this project a...

I am looking for an expert to help restore my SQL Server Management Studio. Unfortunately, I don't have specific details around the version of the SQL Server used or any unique errors experienced, as I missed mentioning those details. Similarly, I am unsure if there have been recent changes to the SQL Management Studio configuration. Therefore, the perfect candidate for this task would be someone proficient in troubleshooting and handling different versions of SQL Server and its Management Studio. Your role will be to restore the system to its full potential without having a detailed error or system configuration history. Skills and Experience Required: - Comprehensive SQL Server knowledge - Experience with SQL Server Management Studio - Pr...

I am in need of a skilled PostgreSQL DBA to assist in setting up and configuring a wide range of enterprise tools. The ideal candidate must have expert knowledge in the installation, configuration, and use of the following tools: - EFM (Enterprise Failover Manager) - PEM (Postgres Enterprise Manager) - EDB Migration - pgBackRest - pgBouncer - pgPool In addition to the initial setup, I require some specific expertise to fully leverage these tools. Specifically, it would be great if you have previous experience with: - Backup and restore tasks using pgBackRest - Connection pooling with pgBouncer - Load balancing with pgPool Please, only apply if you have a proven track record with these PostgreSQL tools as I would like to ensure an efficient setup process. Prior experience with similar p...

I need a serious PHP developer to do some work on my SMF 2.0(.17) Forum Software. The URL of the website is If you are not familiar with SMF you can find an unaltered Stock Version to download...bargaining afterwards. It is ALL in the project worksheet. Check it out carefully and give me your best price only if you are confident you are capable of handling this project All the details of the project are given in the attached pdf. The work will include: - Adjustin and installingpre existting Mod files make them work with my site - Some custom coding - Bug Fixing You need to be good at PHP, SQL, Jquerry, Ajax. Timeframe is up to 20 days I will consider serious offers only from people who carefully read the project worksheet and understand what they are doing

I am seeking a api excel query editor to convert a Postman API call into a Microsoft Query Editor. you need skills in Excel, API utilisation, and Microsoft Query Editor. YOu can see query working in Postman scripts (we have so you can import).

We are seeking an experienced full-stack Developer to join our dynamic team. The ideal candidate should have a minimum of 8 years of hands-on experience in JavaScript and a strong proficiency in the following technologies: NWJS, NodeJS (backend) JS, TypeScript, HTML, CSS, JQuery, MYSQL, WordPress, and AWS. The candidate should possess excellent communication skills, both written and verbal, and be capable of working with minimal supervision. Responsibilities: -- Develop and maintain robust and scalable SaaS and desktop applications using NWJS, NodeJS, JavaScript, TypeScript, HTML, CSS, and JQuery. -- Ensure the technical feasibility of UI/UX designs and implement them accordingly. -- Work with MYSQL databases to handle data storage, retrieval, and manipulation. -- Utilize AWS services fo...

I'm seeking a highly skilled product designer and electrical engineer who can develop and assemble a small, electric plastic product tailored for aerosol spray paints. Key Requirements: - Expertise in designing small, compact items using plastic as the core material. - A deep understanding of aerosol spray paint mechanisms necessary to make the product effective and practical. - Ability to deliver a product design that is ready for assembly and wiring, with an eye towards efficient manufacturing processes. - ability to wire solenoids and small motors and wiring and battery packs Skills and Experience: - Proven experience in product design, particularly with plastic materials and portable objects. - Knowledge about spray paint mechanisms, especially aerosol one...

Looking for help with sheets set up, one must know import range, query features, can write custom scripts codes etc. Someone creative in how to get the things done. Will pay well.

I am looking for a talented and experienced architect who can create a design for a small office building (up to 5,000 sq ft) that complies with vastu principles. In this project, the design should incorporate: - Less than 10 office spaces or workstations - Use of concrete and stone as construction materials Candidates with expertise in both vastu principles and practical office space planning will be given preference. It would also be beneficial if you are comfortable in working with concrete and stone materials for design and construction. Please include your portfolio and past experiences related specifically to small office building designs and vastu architecture. I look forward to seeing your proposed design solutions.

...history, preferences, and behavior history. Experience in efficient data handling and privacy management is required. App in flutter with google maps main objective is to update the customer's data or register a new one and schedule the daily route for the seller. What you generate daily will serve to make this information ready for your attention for delivery the next day and you must connect to db sql server /csv /excel of clients to edit or record data and purchase history this at the time of working with the Google API but to automatically obtain latitude and longitude the supervisor at the end will be able to see the map with all the clients served On the day in them you will know how many are recurring and new. It has a web side where you can import and export the inf...

Greetings, We are in search of an experienced PHP developer who can undertake the task of creating the Human Resource (HR) module for our School Management System developed using PHP, the Laravel framework. If you are interested in this opportunity, please provide a quote based on the attached feature requirements. Preference will be given to individuals who have prior experience in developing HR systems. Thank you for your time and consideration. I am available for online meetings if you have questions. Thanks

I am seeking a skilled WordPress programmer to incorporate a custom search feature on my website. The functionality should include: - The ability to filter results: Users should be able to narrow down their search based on specific criteria. - Auto-complete suggestions: As users start typing, relevant suggestions should automatically populate to enhance usability. The search func...results: Users should be able to narrow down their search based on specific criteria. - Auto-complete suggestions: As users start typing, relevant suggestions should automatically populate to enhance usability. The search functionality should be restricted to post titles and contents only. Only developers with prior experience in custom WordPress search features should bid. Proven expertise in PHP, SQL...

I'm currently in need of assistance with a MySQL query task; specifically how to make use of a subquery in order to yield accurate results in a Select statement. The main purpose here is to fetch data. **** All SQL files are attached to the files for this project. What I am Seeking: Help with the attached query. The query joins two tables. A header and details table. The intent of the subquery in this statement is to find/match a SINGLE "Invoice Date" value in the inv_details table that matches a "PO Date" from the po_details table in the subquery using the main queries currently matching "item" , "ship to city" and "customer name". Using "distinct" in the subquery generates an error (subquery...

I need an expert in PowerBI who is capable of connecting to Excel spreadsheets and SQL databases to create a visually engaging and vibrant dashboard. This dashboard will need to provide: - Detailed analysis of sales performance, enabling a clear understanding of the areas that are working well and those that need improvement. - Thorough customer segmentation that provides deep insights into our customer base to improve marketing effectiveness. - Comprehensive trend analysis that identifies patterns over time to assist in strategic decision making. Ideal candidates should have a strong background in PowerBI dashboard creation and data analysis, as well as a good eye for vibrant and colorful design that can help to bring the data to life.

...wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales Key Responsibilities: 1) Improve angular.js performance then work on transforming angular.js to 2) Front end work migrating our current webapp from angular to , create new pages and functionalities in 3) Developers with experience in .NET API C# are an added plus as is knowledge of WordPress plugins. This is for ongoing long term

Come do interesting GIS programing in a database. *** Please no AI responses. *** Experience with snowflake and other big data a plus. Able to advise and write. Able to work TODAY. Please respond by telling me what is a 3-4. **Requirements:** - Proficiency in spatial SQL -> MUST for complex data query and retrieval. The ability to perform spatial analyses and geometric operations is crucial. - Expertise in creating engaging, interactive maps that can visualize spatial data and analyze spatial patterns on a global scale. This would involve dealing effectively with diverse data sets and potentially large volumes of data. - Strong background in PostgreSQL and PostGIS, with proven experience in writing advanced spatial queries. - Experience in web map developm...

...delete, and route DIDs within the system. Call Feature Configuration: Enable/disable call recording for specific numbers, and set/modify caller IDs. CDR Synchronization: Develop a mechanism to synchronize Call Detail Records (CDR) from FreeSWITCH to a SQL-based application. API Security: Implement robust authentication and authorization for the API to ensure secure access. Requirements: Expertise in ASP.NET for API development, with a strong background in RESTful API principles. Experience with MariaDB, including schema design, and proficient in SQL for database manipulation and management. Familiarity with FusionPBX and FreeSWITCH internals, including database schema and ESL (Event Socket Library). Knowledge of telephony systems and VoIP technologies, specifically related...

...wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales Key Responsibilities: 1) Improve angular.js performance then work on transforming angular.js to 2) Front end work migrating our current webapp from angular to , create new pages and functionalities in 3) Developers with experience in .NET API C# are an added plus as is knowledge of WordPress plugins. This is for ongoing long term

...like Digital Ocean, ensuring high availability and scalability. - Manage databases using SQL, Postgres, and MongoDB, ensuring data integrity and efficiency. - Work with JSON for data interchange and leverage Pandas for data analysis and manipulation. - Conduct web scraping using Scrapy, Requests, Httpx, and implement automation with Selenium for browser tasks. - Utilize Redis and Celery for background task processing and message queueing to enhance application performance. Qualifications: - Proven experience as a Python Developer, with a strong portfolio of projects. - Proficient in Django, Flask, JavaScript, React JS, Axios, Docker, and cloud deployment (Digital Ocean preferred). - Experience with SQL, Postgres, MongoDB, JSON, Pandas, and web scraping tools (Scrapy, Requ...

I'm seeking a highly skilled PHP and Laravel developer for back-end development for my project. The primary responsibilities of the right candidate will majorly involve: - Setting up the server-side lo...efficient, fast and robust code. Although not specified, it would be an advantage if the developer has experience or is comfortable with: - Implementing a user authentication system. - Payment integration. - Developing a data analytics feature. The timeline for project completion hasn't been determined yet, but we will discuss this during the hiring phase. Strong command over PHP, Laravel, SQL and knowledge of AngularJS will be preferred. Prior experience in server-side templating languages and authentication and authorization between systems, servers and environm...

'DB query failed: SQLSTATE[HY000] [2002] No such file or directory'. Mariadb stopped - I need someone who knows about mariadb and plesk

we are looking for a senior PHP developer with a minimum of 16-20 years of experience Skills and Experience MUST HAVE: - 16-20+ years of PHP development experience. - Proficient in Laravel framework. - Experience SQL Injection prevention/fixing - Finding and Securing any loop holes in the system - implementing new features , for enhancement of the platform, - must be an INDEPENDENT developer, not an agency! ********** - must be able to work on GITHUB - MUST be able to change FIGMA design to HTML and implement php pages from it. - lastly making sure platform is mobile responsive Must be knowleadble in updating designs as well when needed. DO NOT BID if you are an agency, if you are a marketing person or project manager. We will only give the project to the independent freelance...

I am looking for a freelancer to create a basic five-page secured WordPress website for a business. You can use elementor or any other theme builder. I have the majority of pages, text and photos ready to go. Create it on your own server and then upload it to mine when finished or any other way you like. This is pretty much a five page job with nothing else such as SEO required.

Need highly skilled freelancers to provide a full set of sealed Electrical, Mechanical, and Plumbing (MEP) drawings for a small restaurant remodel in South Carolina. The drawings will be used for renovation and permit purposes. Ideal Skills and Experience: - Expert knowledge in Electrical, Mechanical, and Plumbing systems. - Experience in producing MEP drawings for small buildings. - Understands renovation requirements and able to incorporate changes efficiently. Prepare to share your portfolio or past work samples related to MEP drawings for renovation projects.

As an owner of a Managed Services Provider (MSP) business with less than ten clients, I'm seeking a skilled freelancer with Azure platform experience for an upcoming project. The proposed scope revolves around the integration of Azure with my MSP business that focuses on IT infrastructure management, network security, and cloud services. I need the solution to include diverse functionalities, including: - Disaster recovery planning, which is crucial for ensuring data security and business continuity. - PBX software for a robust and flexible communication system. - Data backup solutions, to act as the backbone for my data protection plan. - Capabilities for website hosting and software hosting, which are important aspects of my business. Experience with Azure is crucial, and exposu...

I'm seeking a skilled data analyst to help with tasks including data cleaning and preprocessing, data visualization and reporting, and statistical analysis. The data they will be working with is of medium size, ranging between 1GB to 10GB. Prior experience with Python, SQL, and Excel is crucial for this project. Specifically, proficiency with the Python libraries Pandas and Matplotlib is required for the analytics components of the work. This project requires both strong technical skills and a thorough understanding of data analysis methodologies.

I am currently in need of an experienced network engineer who can assist in implementing our company's network. It is a medium scale enterprise with a distributed network across several sites, employing the use of Routers, Switches, and Firewalls, in our network infrastructure. We will be introducing Meraki as the primary network device as the project progresses across the various sites. A. Scope of Work * Implementing the network using Routers, Switches, and Firewalls. B. Required Skills and Experience * Proficiency with Routers, Switches, and Firewalls. Experience with Meraki would be advantageous. * Proven experience in network implementation. * Ability to work in a medium-scale network environment. Ideally, we are looking for an individual who can ensure smooth network operati...

...are seeking a skilled .NET Full Stack Developer to build our website on a contract basis. Responsibilities: • Design and develop our website using ASP.NET, WEB API, Develop user-friendly interfaces using HTML, CSS, and Bootstrap • Implement front-end functionality using a JavaScript framework like Angular or React (familiarity with either is preferred) • Experience with relational databases like SQL Server or Oracle is a plus Qualifications: • Proven experience as a .NET Full Stack Developer • Strong understanding of ASP.NET, NET Core, ASP.NET Web API, HTML, CSS, Bootstrap, and a JavaScript framework (Angular or React) • Experience working with relational databases is a plus This is a contract position, not a full-time or part-time role. To Apply:...

I'm in need of a proficient app developer who can create an application for both iOS and Android platfor...additional feature of exporting the data to an Excel format. Key aspects of the project: - App development for both Android and iOS - Data entry allows manual input by users - Front-end display to present the data inputted - Functionality to export the entered data to Excel The ideal candidate should have robust experience in cross-platform app development, with expertise in .NET, C#, and SQL Server Database. Strong skills in UI/UX design are also preferred to create an intuitive and user-friendly interface. Understanding the requirement of manual input and Excel exportation is crucial for this development job. If you feel this brief fits your capability, please ...

I'm in need of assistance with the creation of high-detail 2D and 3D plans for my ecological straw and wood house located in a village in Normandy, France: - Area: between 50 and 70 m2 (= 538 and 750 square feet) - 1 level with convertible attic. - Wooden structure. - 6000 m2 plot located in the countryside (=65 000 square feet) - Provision of a small terrace on part of the house. - Wall insulation: 100% straw. - Size of straw bales: Height: 37 cm, Width: 47 cm, Variable length: 80, 100, or 120 cm. - Minimize cutting of straw bales for openings (windows and doors) taking into account their dimensions. - Attic insulation: hemp, wood cellulose, or any other ecological material. - Exterior cladding: natural plaster or wood. - Maximize natural light while minimizing energy loss fr...

I'm seeking a tax and accounting professional to conduct simple auditing, prepare taxes, and compile financial statements for my small business with 1 to 10 employees. You should be proficient in using different accounting software including Accurate dan POS. Experience with small businesses is desirable to facilitate a clear understanding of our unique needs. Your responsibilities will include: - Tax preparation - Financial statement creation - Simple auditing Preference will be given to a seasoned accountant with proven proficiency in Accurate dan POS software and a comprehensive understanding of small business operations. The ideal freelancer should be committed to maintaining high standards of accuracy and efficiency.

As a small business owner, I am in need of a professional accountant who specializes in tax preparation. I'd prefer someone with vast experience in this field, particularly working with small businesses. Here are the key areas I need assistance with: • Tax Planning and Advice: I'm not just in need of someone to prepare my taxes. I also want to work with someone who can provide strategic tax planning for my business to ensure I'm making smart financial decisions that will benefit my company in the long run. • Small Business Tax Preparation: Needless to say, you'll be tasked with the actual tax preparation for my small business. This requires a strong understanding of business tax laws and regulations. Ideal Skills: &bull...

...updates: This is the heart of this project. The application needs to furnish real-time price updates every 5 seconds (user configurable) - API Integration: Price data will be expected to be sourced from a reliable API. - User will provide mandatory fields you need to call APIs ( contract-address, chain-id). - Most APIs have a rate limit of something like 120 calls/minute so you need to bundle and query multiple crypto into a single call. Most APIs allow upto 30 to be bundled in one call. - There can be any number of cryptocurrencies to track, anywhere from 10 to 10,000 - so it'd be important to bundle calls to respect the rate limit. Ideal Skills: - Experience with cryptocurrency API integrations (such as GeckoTerminal API, DexScreenerAPI, DexView API - any of those three)...

I am in urgent need of an experienced full stack developer to take on the development of a web application. This individual needs to be adept at handling all aspects of development, from frontend to backend, and even database management. The task requires profici...stack developer to take on the development of a web application. This individual needs to be adept at handling all aspects of development, from frontend to backend, and even database management. The task requires proficiency in the following: - Backend development, - Frontend development, - Database management Skills and Experience: - Excellent command over HTML/CSS - Adequate knowledge of SQL - Strong background in TypeScript The main objective of the project is the development of a unique and efficient web ap...

I'm looking for a skilled freelancer who can help me with a unique requirement. The main objective is to create a code that will: - Load multiple CSV files into one SQL database. - Furthermore, the code needs to delete all duplicate data in the database. I left a few crucial questions unanswered. - First, the ideal programming language for this code is not specified, therefore I'm open to Python, Java, PHP, or whichever language you believe would be most appropriate for the task. - Second, the location of the CSV files was also left unspecified, meaning they could be located in a specific folder or scattered in different locations. Your solution should be prepared to handle either situation. - Lastly, the code's handling of duplicate data was left undetermined. I...

...feedback, and ensure adherence to best practices. Troubleshoot and debug issues as they arise, ensuring timely resolution. Stay up-to-date with emerging technologies and trends in software development. Qualifications: 2- 5 years of experience in full stack development, with a strong portfolio showcasing past projects. Proficiency in programming languages such as JavaScript, Python, HTML/CSS, and SQL. Extensive experience with frameworks and libraries such as React, Angular, Node.js, Flask, Django, etc. Strong understanding of databases and data modeling concepts. Demonstrated expertise in AI and ML, including experience with frameworks like TensorFlow, PyTorch, or scikit-learn. Excellent collaboration and communication skills, with the ability to work effectively in a team envi...

I am looking for a web development specialist with the skills and expertise to build a simple website for me. The project is time-sensitive and I would like to have it completed within a week. The ideal freelancer should be well-versed in web design and development, have experience creating simple websites, and ought to be able to complete the task within the given timeframe. A solid grasp of graphic design and illustration would also be beneficial, but not necessary for completing the job. Looking for MsSQL database , React and .Net developer with strong React knowledge. We run our test automation using robot framework for two websites. We need to show all test suites and test cases on the website when clicked on the test cases' menu. When the user clicks on the test suite, the w...

I'm on the hunt for a professional who can develop an automated system designed to fill up and send queries to a particular website every time new offers are posted. Care to rise to the challenge? What I'm looking for: - Development of a straightforward automation that can fill up and forward queries automatically to a website when new offers are posted daily. - I'm open to innovative ideas and methods to achieve the expected results. What you need to be successful: - Experience in automation development Note: Specifics regarding the website to be targeted will be shared with the chosen freelancer. So, if you can build this kind of system quickly and efficiently, I want to hear from you! Let's chat about how you can help me automate and streamline this process.

I'm in need of a SQL engineer with specialization in query optimization and extensive knowledge of MySQL. The project will involve fine tuning basic single-table queries for better performance in MySQL database. Ideal skills and experience include: - Expertise in MySQL database management - Proficiency in SQL query optimization - Ability to troubleshoot and debug errors Your responsibility would be to collaboratively review the existing database structure, and optimize the SQL queries in order to improve the performance, reduce the run time and the load on the server. This task requires clear understanding of SQL code, MySQL database design principles and industry best-practices. With your technical expertise, I'm looking forward to ma...

I am seeking a proficient PHP programmer for the addition of functions to an existing script. The ideal candidate will have expertise in: - PHP programming - Front-end development (HTML, Javascript) - Back-end development - Database integration (SQL) The main purpose of this project is to build upon and enhance our pre-existing system. Your role will be essential in introducing new functionalities to improve our script. Please only apply if you have extensive experience in these areas. I look forward to potentially working together.

I require a freelancer to create an Excel based tool capable of budgeting the manpower for less than 10 employees. The tool is needed only once to calculate a fixed one-time cost. The scope of this tool should include: * Budgeting of manpower and sales targets * Adding manpower on bump up The ideal candidate will be adept at Excel, more specifically with creating formulas, budget spreadsheets and tools within the application. A background in HR or business finance would be highly beneficial to fully understand the intricacies of employee costs.

We are looking for ETL ODI Developer for...with data quality issues and Exact, Transform, Load (ETL) processes • Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI). • Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis. • Knowledge and understanding of the applicable tools and practices used in data governance including query and data profiling techniques • Proven skills in data analysis – including queries to calculate data quality. • Solid written, verbal, and analytical skills • Strong research and problem determination and solution skill ...

I need a freelancer proficient in data entry to assist with a small project. Based on the following requirements, you will enter less than 100 items of data. Specifics: - Source Format: The data that needs to be entered will be provided in an Excel spreadsheet. - Volume: As previously stated, this is a small project involving fewer than 100 entries. Quick and precise turnaround is required. Ideal Skills: - Proficiency in Excel: Strong working knowledge of the platform is necessary for this project. - Attention to Detail: Given the small volume of data, accuracy with each entry is essential. - Experience in Data Entry: Previous experience will expedite this process and ensure accuracy.

I'm on the lookout for an adept .NET developer with a strong background in jQuery and SQL server. The end goal is to construct an efficient hospitality software. This is an urgent position, ideally located in Nagpur. Primary Requirements: - System development using .NET and jQuery. - Thorough understanding of SQL server operation. Key Features: - Capable of handling billing and invoicing. - Inventory management capability. Ideal candidates would have considerable experience managing comparable projects and deriving software solutions in the hospitality industry. Proven proficiency in .NET, jQuery, and SQL server is crucial to this role. Your proficiency will be key in delivering a quality solution that aligns with our objectives.

I'm in need of an expert PHP developer to craft a complex data query. The project revolves around extracting specific columns from multiple tables (User data tables, Transaction data tables, Customers data tables and Suppliers data table) into a single query. Key Requirements: - Expertise in PHP - Strong experience with SQL and database interactions Brief: I have created four tables named users, customers and suppliers and transactions. In users I have column named uid, name, email, mobile. Here users register themselves for login purpose. In customers table I have column named id, uid, name, mobile, email (here uid is the uid of user who is adding customers and name, mobile, email are the customer’s details). In suppliers table I have column named ...

I'm in need of an expert PHP developer to craft a complex data query. The project revolves around extracting specific columns from multiple tables (User data tables, Transaction data tables, Customers data tables and Suppliers data table) into a single query. Key Requirements: - Expertise in PHP - Strong experience with SQL and database interactions Brief: I have created four tables named users, customers and suppliers and transactions. In users I have column named uid, name, email, mobile. Here users register themselves for login purpose. In customers table I have column named id, uid, name, mobile, email (here uid is the uid of user who is adding customers and name, mobile, email are the customer’s details). In suppliers table I have column named ...

Small start up business needing help with creating an inventory system that is usable. Would like to have some sort of barcode scanning option for the qty of product, as well as some sort of notification when inventory on an item is low

My query below doesnt work i need AS order_total BUT ONLY WHEN = 'ot_total' and i also need AS shipping_method BUT ONLY WHEN = 'ot_shipping' my strategy below failed as it seems i can only use the condition in the normal WHERE clause near the bottom i.e WHERE o.orders_status = s.orders_status_id AND s.language_id = '1' AND = 'ot_total' however this means will return data for the ot_total class but i want it for the ot_shipping class im simply trying to add 2 conditions 1. return AS order_total for the = 'ot_total' 2. return AS shipping_method for the = 'ot_shipping' i dont want for = 'ot_total' so help me ? is this not possible or do i have to execute a completely sepearate