0

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

sql

8/20/2016 7:17:13 PM

Abiodun Olufemi Bayowa

2 Answers

New Answer

+1

yes Ex: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id;

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