answersLogoWhite

0

How do you link the tables in sql?

User Avatar

Anonymous

12y ago
Updated: 8/20/2019

Depending on the DBMS you're using, you link the tables by listing them both in your query, then telling the DBMS how they relate.

For example, in the (semi-)standard SQL language, you might search for customers and all their orders, linking them via a common field, such as customer id.

SELECT customer_id, customer_name, order_id, order_date

FROM customers

JOIN orders ON customers.customer_id = orders.order_id

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

Feature of rdbms?

It stores data in tables. Tables have rows and column. These tables are created using SQL. And data from these tables are also retrieved using SQL


How do you use SQL?

You use SQL by issuing commands to an SQL server, either directly by you or by a program you are using.


What does SQL CREATE VIEW achieve?

SQL CREATE VIEW achieves the creation of a table or tables in the SQL database. One can then create tables to the purpose they desire and fill them in with information.


What is schema in mysql?

Schema is structure you created for your tables in My SQL


SQL statements that define the tables in a database are referred to as?

DDL Statments


What does the Join SQL clause feature in computer programming?

A Join SQL clause is a combination of two or more tables from a database. Fields are joined by using data that is present in both tables and are written as an identification for the join.


Can you link sql to asp?

yes


What training is needed to work with SQL databases?

This unique introductory SQL tutorial not only provides easy-to-understand SQL instructions, but it allows you to practice what you learn using the on-line SQL interpreter. You will receive immediate results after submitting your SQL commands. You will be able to create your own unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables. This SQL tutorial currently supports a subset of ANSI SQL. The basics of each SQL command will be covered in this introductory tutorial. Unless otherwise stated, the interpreter will support everything covered in this course.


How you can uninstall sql 2008?

KB article for uninstall SQL server 2008: at the link below


What is a sql virtual table called?

A SQL virtual table is called a "view". Views are virtual tables that contain the result set of a SELECT query and can be used to simplify complex queries or provide a layer of abstraction over the underlying tables.


To join n tables together you need a minmun of how many join conditions in sql?

glue


The process of designing and creating a set of database tables that avoids redundancies and anomalies is known as?

SQL