ASP grabbing response from multiple tables

[justme77]

Hi all,
I am a new user trying out ASP with MySQL when I come across this problem that needs your help:

Is ASP able to grab data from more than one table at the same time? (i.e to join tables) I've tried using the SQL statement: "select x.name, y.time from table1, table2 where table1.name=table2.name;" It didn't work. Any solutions?

Thanks. cheers,
Just Me!!

 

[TechnicalAnalysis]

What're x and y of x.name and y.time?

There're two syntax that you can try.

SELECT table1.name, table2.time
FROM table1 INNER JOIN table2 ON table1.name = table2.name;


SELECT table1.name, table2.time
FROM table1, table2
WHERE table1.name = table2.name;


Regards

http://www.technical.analysis.dingojunction.com