How to connect three tables in oracle | Sololearn: Learn to code for FREE!
Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок
+ 1

How to connect three tables in oracle

I want to join three tables

4th Feb 2017, 7:44 AM
Ankit Pareek
Ankit Pareek - avatar
3 ответов
+ 11
You can try these queries : 1• select a.acc, b.acc, c.acc from a, b,c where a.acc=b.acc and c.acc = a.acc; 2• select a.acc, b.acc, c.acc JOIN on a.acc=b.acc JOIN on c.acc = a.acc;
4th Feb 2017, 11:24 PM
Hassan Amr
Hassan Amr - avatar
+ 8
@Ankit You are welcome
7th Feb 2017, 6:07 PM
Hassan Amr
Hassan Amr - avatar
+ 2
thanks bro
7th Feb 2017, 4:56 PM
Ankit Pareek
Ankit Pareek - avatar