How can be Marg to table into a one table | Sololearn: Learn to code for FREE!
Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок
0

How can be Marg to table into a one table

there i have a tow table first sellar second id customer how can i join this both table into a one table

14th Oct 2017, 5:35 PM
Toshit Kumar
Toshit Kumar - avatar
1 ответ
0
Use JOIN SELECT * FROM Sellar JOIN Customer ON Sellar.Customer.ID = Customer.ID So you start with a standard select use JOIN name the second table add ON give the name of the column that connects the records, most of the time some sort of ID http://www.dofactory.com/sql/join
14th Oct 2017, 6:53 PM
sneeze
sneeze - avatar