0

Is it possible to get the columns name from a select statement involving more than two table.
eg

SELECT a.field1, a.field2,b.field3,c.field4 
FROM a,b,c 
WHERE a.field1 = b.field1 and a.field1 = c.field1

is there a mysql statement that returns a record set containing field1, field2, field3, field4 that can be sent to an array that can be used in a php script.

Edited by awo: n/a

3
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by hielo
1

You can use a JOIN to link the two tables together. This link will explain the different types of joins.

Votes + Comments
have some more
0

it is not about the join but how to get the name of the return fields

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.