Orale sql number always show decimal places työt
Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.
...from up close. DS is a natural evolution of traditional advertising business, which enables delivery of digital content exactly where the target demographics are. You get to work with visible digital media and see the results of your work first hand. We are a small business and you will be not be hindered by traditional corporate decision-making. If you want to think outside of the box, we are always open to new ideas. The same in Finnish: Xibo CMS - kehittäjä/konsultti räätälöityä Widgetiä varten Tarvitsemme Xibo CMS - alustan käyttöliittymän & konfiguroinnin tuntevan kehittäjän tai konsultin konfiguroimaan ja tarvittaessa ohjelmoimaan yrityksellemme räätälöidyn Widgetin. Tarvitsemme jok...
Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...
Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS
EDIT 2 PHOTOS (CHANGES NUMBER/DATES I NEED TO CHANGE X2 SCREEN SHOTS, CHANGING THE DATES, NUMBERS ETC, 10min job
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
plz give me yours num thankkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
plz give me yours num thankkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
I need addresses and person identifying information from a group of phone numbers and addresses, email addresses…. I need a very professional with a high degree of accuracy to trace a phone number for the purpose of business verification and potential scam. The success of this project is highly dependent on the ability to provide me with real-time information on the location of the user, the user's name, network provider, addresses, aliases, associated records, and any business and personal names linked to the number and other subsequent information discovered. I have multiple phone numbers and addresses and I need an entire comprehensive picture painted to be as rich in intel as possible.... Spider web this out to more info. Some key points: - This requires 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 i...
...Agent: Responsible for handling and resolving tickets. - User: Able to submit tickets and monitor their progress. Ideal skills and experience for the job would be expertise in web development, specifically in creating ticketing systems. Familiarity with user management, role assignment, and priority matrix are essential. Fluent in programming languages like PHP, JavaScript, and proficiency in SQL for a robust database system is a must. Creativity in UX/UI design for an engaging and user-friendly interface should be apparent. It is also required to handle incoming and outgoing E-Mails. I don't want to have further frameworks involved. Core PHP is required and JS like Bootstrap 5, JQuery are ok.I have my own authentication system in place. Based on the role different in...
I am in need of a skilled PHP programmer to address an "undefined variable" error within my user authentication system. The system primarily relies on email and password authentication. Key Requirements: - The error lies within the user authentication system - The primary method of user authentication in the system is email and password Ideal Skills and Experience: - Proficiency in PHP, SQL - Experience with user authentication systems - Familiarity with handling undefined variable errors - Understanding of secure email and password authentication Your task is to identify the root cause of this error and implement a solution to rectify it. Please provide specific examples of similar work you have done in the past.
...competition to ensure we receive only professional designs. This amount is guaranteed as the prize for the best submission. Each proposal must include: 1- Logo 2- Logo and script (Logo + DASMO) 3- Mockup business card 4- Mockup letterhead 5- The logo in action, e.g., on work clothing or on banners in front of a company Feedback and Communication: - Submissions will be reviewed daily, and there will always be feedback for improvement. Freelancers can submit multiple proposals. There are several rounds of approval. File Formats and Specifications: - All necessary working files in formats such as PSD, PDF, EPS, SVG, etc., must be made accessible. The files must be high resolution suitable for production. Language Requirements: - All text elements can be in English, but later on,...
... Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Write clean, maintainable, and well-documented code. Troubleshoot and optimize existing integration solutions. Desired Skills and Qualifications: Strong NodeJs skills Ability to read Python & Go code Abiltiy to write DBT transformations Strong experience with CloudQuery and its features. Proficient in SQL and database management systems. Solid understanding of API integrations and web services (REST, GraphQL, etc.). Experience with ...
The main goal of this project is to find relevant influencers using our Shopify Collabs. Influencers which you will contact, they need to call their followers to install our new android Dance APP. In our APP influencer need to create one new video, and call their followers to dance with them inside our app until the song is finished. App is a new type of "collab dance app" where each user record dance on one small segment of any song (2-4sec) creating a new cool unpredictable music video. You need to try and test our app as well to understand it a bit. Key Responsibilities: 1. Check our Shopify Collabs Account and optimize it using our website, pictures, videos, reels, etc. You can create some pictures, reels as well. 2. Find Influencers using our Shopify Account or maybe you...
I'm looking for a skilled .NET developer with experience in JSON, MS SQL, AJAX, and HTML to help me migrate my existing website to a new template. The specific features that need to be migrated are the design layout and content pages. To give some context, the primary objective of this migration project is to enhance the functionality of the website. An ideal candidate should be well-versed in enhancing user experience and updating design aesthetics. Your role will be pivotal in ensuring that the new template not only preserves the existing features but also improves the functionality. The key difference I'm aiming for in the new site is faster loading times. This means that you should be able to optimize the site's performance and ensure that the migration process ...
...swatches for different sizes and colors. - The website should have an inventory management system that allows for the addition of product quantities in the backend. The quantity should be dynamically updated upon each purchase and trigger a notification to admin in low stock. - The website should have an order management system that send notifications to customers and the owner when a customer places an order. - The website should have a shipping method that allows for self-shipping and integration with third-party shipping providers. - The website should have a shipment tracking system that updates customers and the admin on the status of their orders. - The website should have a secure payment gateway that requires OTP for added security and offers a refund option (My Fato...
...details enclosed+++ Dear Freelancer: I need an experienced game artist to create 4 (FOUR PCS) unique 3D scenes for a mobile game aimed at children aged 6 to 12. Here's what I'm looking for: - You can choose the themes. Be creative and make them standout and interesting. - All scenes should have a 3D pop-up effect. This will help grab the attention of the kids who will be playing the game. ALWAYS understand that its a background scene so leave the PLAYFIELD free for characters!!! It needs to be very present but in a very modest way if u understand what I mean. Ideal Skills and Experience: - Prior experience in creating game scenes, particularly for children - Proficient in 3D design - Ability to make scenes distinctive and engaging - Familiarity with creating a &...
...rental system e) Online car rental system The final submission should include: 1) Report describing the project that includes: a. Introduction b. Web site design c. Web site development: the main files created: articles, categories, modules, and database. d. Screenshots of the website e. Conclusion f. References 2) One folder that holds all the subfolders of categories, articles, menus, modules, SQL 1 files, videos, banners, and images....
I am in need of a proficient freelancer who can scrape image data effectively. This project involves: - Scraping image content efficiently from various types of websites. - No particul...scrape image data effectively. This project involves: - Scraping image content efficiently from various types of websites. - No particular specification was given about the type of websites to scrape from, so flexibility in handling different sites is essential. - The timeline for project completion was not specified, suggesting flexibility in delivery time, although efficiency and promptness are always appreciated. Ideal Skills: - Proficiency in data scraping - Ability to handle varying website formats - Strong work ethic and punctuality in project completion - Attention to detail when scrapi...
I am in immediate need of a Python expert who can extract data from external website and store in an MS SQL database. freelancer with extensive experience in data extraction from varied sources would be highly desirable. The skills and experience required for this job includes: - Extensive knowledge on Python-based data extraction methods - Proven experience with managing and manipulating MS SQL databases - Ability to adapt to multiple and potentially unexpected data sources - willing to work via anydesk for final installation of the project Given the urgent nature of this project, only those who can demonstrate a commitment to quick turnaround times need apply.
I'm seeking a Laravel developer to undertake some functionality changes in my existing site. The project will involve: The suitable candidate will be able to demonstrate prior experience in these areas as well as a deep understanding of Laravel. Past work and detailed project proposals are appreciated for thi...functionality changes in my existing site. The project will involve: The suitable candidate will be able to demonstrate prior experience in these areas as well as a deep understanding of Laravel. Past work and detailed project proposals are appreciated for this application, they give me a sense of your style and approach. Although there are currently no plans for design updates; however, suggestions are always appreciated. Let's refine my site and bring it to the ...
...afterwards a paid test task. Payment? - you estimate in a WBS (optimistic, expected, pessimistic, where optimistic < expected < pessimistic) after getting the task - we discuss about clearances and effort - we mutually agree to effort - we agree to delivery dates - we assign you the task after mutually agreed - you implement, test and deliver - you provide also unit /integration tests to ensure code is always working - you document each required step to make interaction of systems to work - we test on our premise (you maybe help to fix issues) - we pay (basically the rules of freelancer) Closed book vs open book? We work only on open book. Closed book means you are unwilling to define a WBS for the work and you add only a price tag to the task. We are sorry we will not ...
...Minimum of 10 years' practical experience in cybersecurity, preferably with recognized companies. Proficiency with various cybersecurity tools and programming languages. Expertise in identifying and mitigating risks, threats, and vulnerabilities. Technical Skills: Hands-on experience with Security Information and Event Management (SIEM) tools. Proficiency in Python, Linux, and SQL. Knowledge of CIA Triad, governance, risk analysis, compliance, and business continuity planning. Familiarity with Linux and Windows server configuration, Active Directory, network architecture, operations, and security. Experience in areas such as Wireshark, email security, wireless security, cryptography, port scanning, cloud security, and virtualization. ...
I am in need of a reliable freelancer for a short, simple typing task involving less than 10 pages. While the purpose of this project was not specified, the task is solely focused on typing. Ideal Skills and Experience: - High accuracy in typing - Speed in output - Past experience with similar tasks Application Requirements: Although this section was skipped, it's always helpful to know more about your previous work and experience. Details about similar tasks you've accomplished will be appreciated. Remember, accuracy and speed are key for this assignment, so only bid if you are confident you can meet these parameters.
I am seeking an experienced software developer with expertise in creating robust web application...analysis for better decision making Needed Functionality: - Inventory management system: The application should keep accurate track of the inventory levels and alert the users when restocking is needed. - Payment management: The application should be capable of processing payments, invoices, and balancing accounts. Ideal Skills: - Proficiency in back-end and front-end development - Knowledge in SQL for database structure - Understanding of payment gateways The successful freelancer should exhibit strong understanding of cloud infrastructures and advanced data security measures. Experience in creating similar systems would be a significant advantage. The simpler the application UI, t...
I need an experienced developer with proficiency in both Vue.js and .NET, capable of delivering the pro...applications. - **Project Details** - The developer is expected to create an enterprise application with an interactive UI. - I place a significant emphasis on an engaging, usable and intuitive interface. - **Timeline** - The project needs to be completed ASAP. So, I'm looking for someone who can dedicate sufficient time immediately. -** Vue.js 2 and 3 experience ** with .Net Web API and sql server required on expert level Ideal candidates can demonstrate previous experience working on similar projects and have a strong understanding of UI/UX principles. this a NDA Project and no code will be share and is a remote work, NO PHP folks needed or bid on this proje...
I require the services of a travel agent who can find me a hotel business that will allow me to stay at their hotels for $1,600/mo. Key Requirements: - Budget of $1,600mo - Must be able to stay at different places every night because I travel a lot - Must allow dogs - Booking Hotels: You should have experience in booking hotel accommodations and be able to provide a range of options to suit my preferences. - Flexibility: The preferred location of the hotels varies for each day and month, so the ability to adapt to the changing requirements is a must. Timeframe: - The project needs to be completed ASAP. Ideal Candidate: - A skilled travel agent with a strong network in the hotel industry. - Excellent communication skills and attention to detail. Your role will be crucial in ensu...
...to an Excel file. I do it manually (copy/paste), but I need a tool to have it done automatically. These invoices have a consistent format structure, and the fields I need to copy to Excel are always the same. They are informations like: invoice number, date, customer's name, product code, price, etc. All the fields that need to be on Excel are highlighted in color red on the 2 files I'm providing as an example. Any other info not highlighted in red, doesn't need to be on Excel file. The automation process must execute without fail, ensuring that the location of highlighted fields - which are always the same in every file - does not affect the extraction. The only difference you'll see between the invoices is that most of them (maybe 90% or more...
... but tailored to our specific needs, including custom graphics and a unique logo that represents our brand identity. KEY REQUIREMENTS Languages and Frameworks: - Frontend: Expertise in HTML5, CSS3, JavaScript, and experience with frameworks like React.js or AngularJS. - Backend: Proficiency in server-side languages such as PHP, Python, or Node.js, with database management using SQL or MongoDB. - CMS Experience: Capability to integrate and customize content management systems (CMS), preferably WordPress or Drupal. Design and Graphics: - Creation of a unique logo and custom graphics that reflect our brand and the services we offer. - Design a responsive and accessible website that adjusts smoothly to different screen sizes and devices. - Clear and intuitive navigation system
I'm urgently in need of a qualified developer to create a pipeline utilizing DBT and SQLLITE. T...appropriate error logging and handling mechanisms Ideal Skills and Experience: - Strong proficiency in DBT and SQLLITE - Experience with data pipelines, specifically involving text file processing - Familiarity with data transformation techniques - Quality assurance and bug fixing capabilities Deliverables: ● A DBT project containing models for company_analytics and skills_analytics tables. ● SQL scripts or DBT models to process JSON files and populate the analytics tables. ● Instructions for running the DBT command to process the data and execute data quality checks. ● Documentation on adapting the pipeline for continuous file deliveries and suggested additional data quality me...
I need a power BI expert with deep knowledge of DAX que...help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow colum...
I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particula...in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, MySQL, O...
...following: A menu bar: Blogs button (to route the user back to the /blogs page), shop button (to route to /shops), About us (to route to /about-us) A title with writer name A carousal of slides which gives a short read to the blog Article starts with the letter T from the logo of Kalataru The article should have social media share links under it, with comments below The article should have interesting places to post ads The article will have: the blog, a featured image, inline images and carousal images Any new blog should be easy to add from the UI of wordpress - The marketplace landing page should contain: A menu bar: Blogs button (to route the user back to the /blogs page), shop button (to route to /shops), About us (to route to /about-us), Categories (to display various cate...
I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience in configuring hostin...
I need to manually add text and picture annotations to a PDF document . I have a pdf document but pictures do not show up some places in the document, I have the pictures and need someone to have two columns with the original on the left and add the pictures in a second column on the right of the original document where they should have been inserted . there are about 15 photos that need to be matched up . should not be more than 2 hours . also there are 8 names that need to be inserted wherever they show up in the document .
As a business user, I need assistance with the configuration of SS...WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the call since this is a secured environment. Also, this needs to be executed...
... we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a dedicate...
I need a Power BI expert with deep knowledge of DAX que...retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow colum...
...the admin panel. Customizable Hosting Packages: Ability to define various hosting packages with different storage sizes, number of email accounts, etc. Dual Access: Users must be able to manage their account from the WordPress site and the main hosting control panel. Requirements for the Snipepay Payment Plugin: WooCommerce Integration: Develop a payment plugin to integrate Snipepay into WooCommerce, allowing users to choose Snipepay along with existing options like PayPal and GoUrl for payments. Deliverables: A fully functional WordPress plugin for hosting management. A Snipepay payment gateway plugin for WooCommerce. Skills Required: Proficient in PHP, JavaScript, and SQL. Experience with WordPress and WooCommerce plugin development. Strong understanding of RESTful AP...
...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...
I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.
I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criter...