Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

Home Forums How to add(merge) three or four table in a single SQL query ? – MindStick
Ask Question

2 Answers

Nitin Lahoti
Nitin Lahoti 11 Dec 2018
Report Abuse

I would like to suggest join concept to add multiple tabe in a single query as per above post mr.SANAT  plz use this one.

Anonymous User
Anonymous User 27 Nov 2018
Report Abuse

Hi, Rahul

Please, use this query ...

1). If you want to Merge Two Tables...

SELECT * FROM 

Table_1

FULL OUTER JOIN

Table_2 ON Table_1.colomn_name = Table_2.column_name

2). And if you want to add three or four table by a single query...

SELECT * FROM 

Table_1
FULL OUTER JOIN

Table_2 ON Table_1.EmployeeName = Table_2.EmployeeName

FULL OUTER JOIN 

Table_3 ON Table_2.EmployeeName = Table_3.EmployeeName

Note - Foreign keys must be used in all the tables in which the tables that we call them to join. This means that all those tables should have a common column name.

advertising
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md