How can I join two tables in database?



How can I join two tables in database?..

Answer / Ravi Kumar Shukla

To join two tables in a relational database, you use the JOIN clause. For example, if you have two tables A and B, and there is a common field (e.g., ID) between them, you can join them with a SELECT statement like this: SELECT A.* FROM A JOIN B ON A.ID = B.ID.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

What is difference between database and file?

1 Answers  


How to debug stored procedures?

1 Answers  


How can I access my database remotely?

1 Answers  


Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?

1 Answers  


What is dbms function?

1 Answers  


What type of file is used for porting Forms 4.5 applications to various platforms?

1 Answers  


Explain meant by 3-tier architecture?

1 Answers  


Can I use google sheets as a database?

1 Answers  


Define view, sequence and index in DBMS.

1 Answers   HAL,


What is the use of GRANT option in EXP command ?

1 Answers  


What is big data in database?

1 Answers  


What are different types of transaction isolation levels?

1 Answers  


Categories