SQL syntax for retrieving multiple results from three tables.

Question

I have been able to retrieve multiple records from the same table by the syntax;
$sql="SELECT * FROM myTable ";
in phpMyadmin. But how to retrieve multiple / many records from different tables?

Answer 1

If you want to mix some fields from several tables you can use JOIN. But you can't grab all records from several tables with SELECT * because there are differences amongst their structure, number of fields etc.

Answer 2

Thanks Ipang hope this will help me a lot.

Answer 3

Thanks Ipang it worked as i expected