Programación de bases de datos Jobs

Looking for an expert in Oracle Utility Application Framework (OUAF) technology who can assist me on a project urgently. Task Components: - Designing intuitive and efficient user interfaces. - Developing custom functionalities as per the project's requirements. - Implementing data integration for seamless information flow. While the main purpose behind this project hasn't been detailed out, the chosen tasks indicate it would greatly aid in streamlining processes or improving data management. Hence, the project might have leanings towards enhancing the efficiency of business operations. Ideal Candidate: - Proficient in designing UI for OUAF. - Track-record in performing custom functionality development. - Proven skills in implementing data integration on OUAF. - Availabi...

I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!

I'm urgently in need of a skilled professional who can assist me in putting together a dataset of Arabic calligraphy text images. This dataset will be crucial in training a machine learning model. The ideal candidate will: - Have experience in dataset creation especially for image-based deep learning generative tasks. - Have knowledge or interest in Arabic calligraphy text to ensure the quality and relevance of the images. Your timely completion of this project will directly impact the progression of my ML model's training. Looking forward to your proposals!

I'm seeking a developer who can take on a project where the main goal is to create interactive reports using ActiveReports. Mainly just need help with c# scripting Key Requirements: - **Data Source**: The reports will need to pull data from databases. - **Functionalities**: The interactive reports should allow users to filter and sort data. Additionally, time metrics from the database should be displayed in a user-friendly manner. Ideal Skills: - Strong experience with ActiveReports or similar reporting tools. - Proficient in integrating reports with databases. - Previous work on creating interactive reports with filtering and sorting capabilities. - Excellent understanding of time metrics and data visualization.

The objective of this assignment is to develop a comprehensive database system. The Database should support, among others, member registration, subscription tracking, member services management, and trade references. The system should facilitate data import from Excel and accommodate online and offline accessibility based on the user’s capacity to meet online hosting costs. Member Registration: Develop a module for member registration capturing key details such as Name, address, and any other contact information. Village, group, area, district, province, sub-group affiliation (e.g., Study circle, VSLA, commodity association etc.) Demographic information (age, gender, household size, etc.) Implement functionality to adapt and import member data from Excel sheets. Enable different a...

Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep knowledge of re...

I'm in need of a skilled Oracle Apex developer to help with the data management of our company's financial records. The main goal of the project is to create a user-friendly web interface that can efficiently manage and present financial data. Key requirements include: - Expertise in Oracle Apex and proficient in data management - Experience working with financial records and data - Ability to design and develop a user-friendly web interface - Strong understanding of data security and confidentiality - Excellent attention to detail and accuracy The successful candidate will be able to streamline our financial data management processes, making it easier to access and utilize the data for various purposes within the company.

Project Details: We are looking to find a way to match extracted data from a document to certain specific fields in our own system. For example, a data extracted from a document can be [Customer Name: Company ABC PVT LTD], but in our system the field may be called [Client Name]. We want the LLM to help match Customer name and Client name, so that the data gets filled into the field in our system. I am looking for a long term freelancer with database development, LLM and AI experience to help us achieve highly accurate results using OpenAI API, and ideally speaking some experience in google cloud AI products. Specific requirements for the project include: - Experience with LLM models, particularly the specified model - Strong understanding of programming languages and development of ...

I'm in need of advanced Q Learning expertise to optimize decision-making within a signal time optimization task, leveraging this powerful machine learning approach to enhance the efficiency and performance of my system. Key Requirements: - Implementing Q Learning: You should have a strong grasp of Q Learning algorithms and be able to effectively apply them to my specific use case. - Optimization of Decision Making: The primary goal here is to improve decision-making in a time optimization setting. Your work should be geared towards achieving this through the application of Q Learning. - Signal Time Optimization: The Q Learning model will be specifically tailored to a signal time optimization environment. You should ideally have experience in: - Working with Q Learning in real-world ...

I am seeking a freelancer who can efficiently develop an ER (Entity-Relationship) model for a targeted domain, specifically incorporating the relationships and entities of Customers and Orders. Key requirements include: - Proficient expertise in ER modeling - Ability to capture and incorporate Customers and Orders as specific entities and relationships in the model. - Ensure that the 'Customers' entity accurately stores 'Name and Contact Information'. Ideal candidates should have a solid understanding and experience in designing ER models, with a sharp eye for capturing accurate details in such systems. Timely delivery of the project will be a critical factor to consider. Kindly include your relevant skills and experiences in your bid. Looking forward to working with...

Create a relational database for the following data in a single tables with parts store. You may use alphanumeric to represent store and use surrogate key as primary key. Bring a hard copy in class and answer two quires in class. (points Project creation 20 + two query 20) 1. Vendor 1: Low Hardware, 1200 Harding st, Pine Bluff, AR 71602, Phone 870-535-1000 Supplies screw Size Steel Size Unit Price QTY Stainless Steel QTY Unit Price 6-32 Yes ½” .02 300 Yes 100 .04 6-12 Yes 3/4” .03 300 Yes 200 .06 6-32 Yes 1” .04 400 Yes 200 .08 6-32 Yes 1 ¼” .05 300 No 0 .10 6-32 Yes 1 ½” .06 500 Yes 20 .12 8-32 Yes ½” .04 300 Yes 200 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 Yes ¾” .06 40...

FOR MELBOURNE BASED FREELANCERS ONLY I am a finance professional with over 30 years experience in the investment markets. I need an experienced tutor in Microsoft Access to assist me with database creation and query design and optimization. The ideal candidate should be able to help me understand: - How to create a well-structured database in Microsoft Access - The best practices for query design and optimization to enhance the efficiency and speed of the database operations You should also be able to provide guidance on: - How to maintain a clean and minimalist design that is easy to navigate - The creation of a user-friendly interface that is intuitive and easy to interact with - The customization of templates to suit specific requirements The completion timeframe ...

I require a freelancer to extract and consolidate numeric data from existing databases. The data should be transformed and presented in a workable database file format. Key responsibilities include: - Extracting data from various data sources - Ensuring data integrity and quality - Transforming the data into a database file format Ideal Skills and Experience: - Proficiency in database management and data extraction - Strong understanding of data transformation - Attention to detail and precision - Ability to ensure data quality and integrity - Prior experience working with numeric data is a plus.

I'm currently experiencing some problems with my Spring Boot and database backend, namely (but not exclusively), data inconsistency and significant performance issues. • Data Inconsistency: There's a rampant issue of missing and incorrect data circulating within the system. This issue impacts the integrity of the entire project and lowers its efficiency. I am seeking a professional who can help identify the source of the inconsistency and implement a permanent fix. • Performance Issues: I am dealing with certain performance issues, specifically very long database queries. Additionally, the task reassignment isn't functioning as it should, and data entry is also compromised. Ideally, I'm looking to enlist the services of a professional who possesses a strong...

I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - E...

I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - E...

Χρειάζομαι άτομο για τη δημιουργία database σε excel

I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.

I'm looking for a talented freelancer to build a custom table that can accurately determine partners' collection and payout within our dental practice. This table should be flexible enough to allow for the substitution of various numbers, which in turn reconfigures the other numbers in the table. Key Components: - The table will need to calculate individual doctors' collections and revenue based on specified variables - Additionally, the table will need to factor in: - The predetermined variables for calculating individual doctors' collections and revenue - Management fees - The table will also need to consider the partner's percentage ownership for each partner in the practice. This percentage ownership will be calculated based on the individu...

I'm searching for a savvy data analyst to create a live database for personally evaluating used cars. Your work should enable me to input a car type and receive a comprehensive valuation. Key tasks: - Develop a synchronized database by drawing data from multiple car sale platforms including Autotrader, Facebook Marketplace, Gumtree, and Car sales. - Ensure that the database is equipped to effectively provide the following information from each platform for every vehicle: Price, Mileage, Year and Condition. - - Find current and historical used car price data using carsales, facebook, gumtree, autotrader, Make, model, badge - Average days on market - Lowest price, highest price, median price - How many currently for sale on each platform - Cars sold in last 12 months Filters: -...

I'm looking for someone who can help me pivot and enhance the segmentation of our user data, which is currently stored in a database. Key Tasks: - Pivoting User Data: The primary goal is to reorganize the data to facilitate a more refined segmentation of our users. - Improve Segmentation: This process should result in a more detailed and sophisticated user segmentation structure. Ideal Skills and Experience: - Strong Data Pivoting Skills: Proficiency in restructuring data in a way that's beneficial for segmentation. - Data Analysis: Ability to analyze the data and identify patterns for improved segmentation. - Database Knowledge: Since the data is currently stored in a database, experience with database management is essential. - User Segmentation: Previous experience with user...

I'm seeking a Mainframe Engineer to take over the maintenance, database management, and performance optimization of our Mainframe systems. The ideal candidate should be proficient in the following technologies or platforms: - IBM z/OS - COBOL - DB2 Please submit your proposal including your experience with similar projects.

We are seeking a team of Database Engineers who can combine multiple sources of data into an Azure MySQL database on an automated basis. The operation must comply with HIPAA regulations under an organizational development environment (VDE). All VM's and databases will be deployed through Azure.

I need to integrate Tableau with my SQL database, and I'm looking for a skilled freelancer to handle this. Key Responsibilities: - Setup Tableau integration with SQL database - Ensure seamless connection and data flow between the two - Deliver a functional, user-friendly interface for data visualization Ideal Skills: - Strong experience with Tableau and SQL - Excellent understanding of database management and integration - Ability to create interactive dashboards - Proficiency in optimizing data for Tableau visualization This project will require a keen eye for detail and a commitment to delivering a quality, tailored solution.

In my ongoing project, I'm facing a thorny issue. Some numeric data is missing from the transaction data table in our MySQL database report. In order to move forward with my work, I need a professional to: - Diagnose the source of this missing data - Fix the issue to ensure all numeric data is correctly pulled into the report from the transaction data table The successful candidate should have: - Extensive familiarity with MySQL databases, specifically in generating and troubleshooting reports - Sound understanding of database architectures and data tables relation - Proven problem-solving abilities I look forward to your proposals and getting our report up to speed.

I need help reducing the size of my WordPress website's database. The primary reason for this is to lower hosting costs. Key Areas for Optimization: - **Back-end Operations Speed**: The site's backend is significantly slowed down due to the large database. I need a solution that will significantly improve the speed of my back-end operations. Data Types to Address: - **User Data**: The large volume of user data on the site is a significant contributor to the database size. I need to find ways to optimize or archive this data without compromising its integrity. - **Media Files**: The site is media-rich, and the files are taking up a lot of space in the database. I need to find a way to reduce the size of these files without compromising the images or videos' quality. - **Lo...

I'm looking for a skilled and experienced professional to create a comprehensive Farsi database for advanced language learning purposes. This database will be used as a refrence for a text generator Ai Key Project Details: - The focus of this database should be on advanced-level language content - Content should include a mix of literary texts, technical documents, everyday conversations, as well as other forms such as books and poems. Ideal Skills and Experience: - Proficiency in Farsi language - Experience in creating educational content, particularly for advanced learners - Ability to source and organize a variety of content types, including literary and technical material - Strong understanding of language learning methodologies and best practices - Familiarity with databases a...

Hello All, Need below resource on monthly basis. Its totally remote work. Tableau Admin JD - ( 4+ years of exp )( Payment is between 60k to 80K Per Month ) Should have good experience about configuration, migration, upgrade, and maintenance of Tableau Server/Online Tableau Architect JD - ( 6+ years of exp) ( Payment is between 80k to 1 Lac Per Month ) good experience on complex schema building. PLEASE REPLY ONLY YOU MATCHED WITH BUDGET AND READY TO WORK ON MONTHLY BASIS FULL TIME. More info will be share later. Thank You

We already have a database built in Air Table and would like to go back to Access. It would be a fairly straightforward process to see what we have and work to recreate in Access. Prefer English speaking and US resident for ease of communication.

I'm experiencing some issues with my Access database. The data seems to be missing or incorrect. Moreover, I need to add new functionality. The additional function is generating reports. Although I haven't specified the type of reports, I expect freelancers bidding for this project to possess experience in various types of reporting functions. Skills required are: - Proficiency in Microsoft Access - Experience in fixing data errors - Expertise in implementing reporting functions in a database It's crucial that the freelancer grasps the issues and rectifies them, and demonstrates an understanding of database reports functions to add onto the system. Bids from freelancers with relevant experience and skills are welcomed.

For this project, I am looking for someone to help me store market data from Interactive Brokers API, specifically stock prices, into a MySQL database. Key requirements for the project include: - Api should be in either js or python - Experience with Interactive Brokers API: The freelancer should have a solid understanding of retrieving data from this particular API. - Proficiency in managing MySQL databases: As the goal is to store data in a MySQL database, experience in this area is a must. - Understanding of market data and stock prices would be beneficial to align the project goals and outcome successfully. I look forward to working with a dedicated professional who can seamlessly bridge the gap between the Interactive Brokers API and my MySQL database with accurate stock price dat...

I'm seeking a skilled Python programmer to create a comprehensive Family Ancestry Tree generator from my PostgreSQL database. This project's main objective is to use the data for analysis. Therefore, the tree must be designed to facilitate easy data interpretation and discovery. Specifications: - The tree must visually demonstrate multi-to-multi relationships such as Biological, Marital, and In-Law relations. Examples of these are Father, Mother, Son, Daughter, Wife, Father-in-law, Mother-in-law, etc. Ideal Candidate: - Strong experience in Python or the latest programming technology. - Proficiency in database connectivity and operations, specifically PostgreSQL. - Background in data structures, particularly tree structure, is vital. - Previous experience in data analysis ...

I'm seeking a skilled developer to create a minimal viable product (MVP) for an extraction web application. Here's what I need: - Extract key performance indicators (KPIs) from specific tables in a database. - The tables to focus on are those related to Agrofood data, particularly those providing comprehensive details on KPIs. - The extracted data should be organized and prepped for the generation of action plans and export. Ideal Skills and Experience: - Extensive experience in database management and data extraction. - Knowledge of Agrofood data and related KPIs. - Capability to design an extendible MVP for further developments. - Proficiency in web application development. To be successful in this role, you need to produce accurate and useful data that will help steer st...

**Project Description: Database Creation with GPT Assistance in Excel** **Overview:** The aim of this project is to leverage the capabilities of OpenAI's GPT (Generative Pre-trained Transformer) model to assist in the creation of a comprehensive database using Microsoft Excel. The database will serve as a centralized repository of structured information, facilitating efficient data management and analysis. **Objectives:** 1. Develop a structured database architecture suitable for the organization's requirements. 2. Utilize GPT to automate data entry, validation, and enhancement processes. 3. Ensure data integrity, accuracy, and consistency throughout the database. 4. Enable seamless data retrieval and reporting functionalities. 5. Facilitate collaboration and knowledge sharing ...

I have an existing Microsoft SQL Server database that I'm looking to migrate to a NoSQL database system. Ideal skills and experience: - Strong experience with database programming - Previous database migration experience - Proficient in both Microsoft SQL Server and NoSQL databases Please let me know your experience in such projects and the approach you would take to ensure a smooth and successful migration.

I have an existing Microsoft SQL Server database that I'm looking to migrate to a NoSQL database system. Ideal skills and experience: - Strong experience with database programming - Previous database migration experience - Proficient in both Microsoft SQL Server and NoSQL databases Please let me know your experience in such projects and the approach you would take to ensure a smooth and successful migration.

I have an existing Microsoft SQL Server database that I'm looking to migrate to a NoSQL database system. Ideal skills and experience: - Strong experience with database programming - Previous database migration experience - Proficient in both Microsoft SQL Server and NoSQL databases Please let me know your experience in such projects and the approach you would take to ensure a smooth and successful migration.

I'm in need of a Java desktop application that operates as a table top game manager for solo play. The ideal candidate will have experience in Java, NetBeans and 2D6 game terminology. Key Features: - Rule Enforcement: The app should ensure that the game is played according to the set rules. - Turn Management: The application is responsible for managing the flow of turns in the game. - Dice Rolls: The app should include a random dice roll feature. Ideal Skills: - Proficiency in Java - Experience with NetBeans - Understanding of game terms like 2D6 and D66 - Experience using Apache Derby Database jdbc network connectivity (e.g. jdbc:derby://localhost:1527/dbname) Deliverable: A well designed, complete NetBeans Java Swing Application project folder that I can open in NetBeans and e...

I'm on the hunt for a vibrant, knowledgeable Microsoft SQL trainer for my client who can help me elevate skills to an intermediate level. Fluent Tamil communication is a must as I feel most comfortable learning in this language. Key Learnings Expected: - Database Creation: Learn how to build an efficient and well-structured database from scratch. - Querying and Managing Data: Gain expertise in extracting, manipulating, and managing data. - Advanced SQL Concepts: Explore more sophisticated SQL concepts to comprehend the language's full capabilities. Ideal Freelancer's Profile: - Experienced MS SQL tutor with a strong understanding of database creation, handling data, and advanced SQL topics. - Proficiency in teaching in Tamil. - Proven experience in educating and simplify...

I'm in search of an experienced MS SQL professional who can provide online training that covers from intermediate to advanced concepts. This will focus particularly on, but not limited to: - Database Administration - Query Optimization - Stored Procedures Ideal Qualifications: - Proficient with MS SQL - Previous experience in teaching or training - Ability to explain complex concepts in a simple, understandable manner - Capable of tailoring the lessons to my specific needs No preference on the tools or software versions for the training as the focus is more on learning the subjects rather than mastering specific tools. Feel free to propose the platform or versions you are most comfortable teaching with.

Seeking a SQL specialist (4-5 hr/day part time remote job) excelling in data partitioning, indexing, complex query calculations, and impeccable SQL design. Here's a snapshot of what my project entails: - Enhancement of a medium-scale database (1,000 - 10,000 records) using best practices - Expertise in SQL Design for efficient data management - Aptitude for complex query calculation to enhance speed and accuracy - Proficiency in data partitioning and indexing - Equally prioritizing both query optimization and database design - Excellent communication skills for steady project updates Ideal candidates must have a knack for balancing database design and query optimization. Let's push the boundaries of what SQL databases can achieve together!

write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru

I need a NoSQL database system that can effectively manage our company's purchases, production, and inventory. The project needs to be completed within a month. Attached the Project details ... Key Features Required: - Scalability: The system should be able to handle large amounts of data and growing demands. - Flexibility in Data Modeling: I'm looking for a system that can adapt to our changing business needs without compromising on performance. - High Performance: It's crucial that the system can process data efficiently and provide real-time insights. Ideal Skills and Experience: - Proven experience in designing and implementing NoSQL database systems. - Strong understanding of data modeling and its impact on system performance. - Ability to deliver a scala...

I am looking for an expert who can assist in creating and optimizing Microsoft Forms. The focus would be on: - Developing surveys and questionnaires for data collection. The job also requires proficiency in QR code creation that will serve for: - Collecting registration-related information. The forms should be user-friendly and accessible via both desktop/laptop computers and mobile devices. Ideal Skills: - Expertise in creating and managing Microsoft Forms. - Proven track record in QR code generation and implementation. - Strong understanding of user experience on different platforms (desktop/laptop, mobile).

I require a proficient Pl/SQL programmer to assist me in writing stored procedures for my database. Your primary goal is to focus on the programming aspect of Pl/SQL, specifically in creating stored procedures. This is key to the project and will require a deep understanding of both database management principles and the syntax of Pl/SQL. Key skills and experience needed: - Proficiency in Pl/SQL programming - Proven experience in writing stored procedures - Strong understanding of database management and architecture - Excellent problem-solving skills - Attention to detail and accuracy in coding Your work will contribute significantly to the efficiency and effectiveness of my database system. Please be sure to have a portfolio or examples of your previous Pl/SQL work to showcase your ca...

I am in urgent need of a developer to help me delete some crucial files from my server's database. The files in question are related to both orders and affiliate data. Key details: - Urgency: This task needs to be completed within 24 hours. The files do not involve any specific criteria for selection. The process is straightforward, and all relevant files need to be removed. Ideal skills and experience: - Proficiency in database management and SQL - Experience in managing ecommerce and affiliate systems - Ability to work under tight deadlines - Good communication and collaboration skills

I'm in need of an experienced Budibase developer to create a fare collection system with a PostgreSQL database backend. The system needs to be web-based and compatible with all major operating systems. Key functionalities and features include: - Ticket Purchasing: The system should allow customers to purchase tickets through a user-friendly interface. - Fare Calculation: It should have the capability to calculate fare based on distance, time, or any other parameters provided. - Payment Processing: The system will need to support secure and reliable payment processing for the purchased tickets. For this project, I need someone who is well-versed in Budibase development and has experience in creating similar fare collection or ticketing systems. A strong understanding of PostgreSQL fo...

I want to switch reading input from a file to reading from a database table. This can be achieved through the creation of a MySQL database table and performing some essential CRUD SQL statements. Upon completing this, I should be able to: • From a PHP page, create a MySQL database • From a PHP page, create the appropriate tables • From a PHP page, apply CRUD operations using SQL language

I am looking for a detail-oriented freelancer to help convert my existing Excel spreadsheet data into a database format. Requirements: - Import and convert Text Data from Excel Spreadsheets to Database format - Accurate and efficient data entry skills required - Prior experience with Excel and database formatting is a must - The candidate should have an eye for detail and be well-versed in data management By the end of the project, I expect all data from the Excel spreadsheet to be neatly structured and readily accessible in the new Database.

I'm experiencing performance issues with 5 stored procedures in my SQL Server. These procedures are significantly slower than expected due to complex JOIN queries involving multiple tables. The project entails: - Diagnosing the cause of the slow performance. - Improving the efficiency and speed of these 5 stored procedures, aiming to achieve at least a 50% increase in speed. - Decreasing high memory usage of a sql server instance Ideal skills and qualifications: - Proficiency in SQL Server and complex JOIN operations. - Proven experience in SQL query optimization and performance improvement. - Understanding of advanced aspects of SQL Server performance tuning. - Excellent debugging and diagnostic skills. - Familiarity with procedures handling multi-table JOIN queries. GetInvKard...