can I SELECT query from two different tables at the same time. | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

can I SELECT query from two different tables at the same time.

20th Aug 2016, 7:17 PM
Abiodun Olufemi Bayowa
Abiodun Olufemi Bayowa - avatar
2 Answers
+ 1
yes Ex: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id;
20th Aug 2016, 7:42 PM
Tiger
Tiger - avatar
0
Yep. SELECT Client.ID, transacrions.number FROM Client, transacrions LIMIT150 or else SELECT c.ID, tr.number FROM Client c JOIN transacrions tr ON tr.client_ID = c.ID LIMIT 150
21st Aug 2016, 2:13 PM
Petrovich
Petrovich - avatar