TalkPHP - View Single Post - Search query multiple tables? (PHP, MySQL)

Wildhoney · 06-15-2009, 04:17 PM

You can use the AS keyword for that.

sql Code:

SELECT
    myTable1.id AS myTable1_Id,
    myTable2.id AS myTable2_Id
FROM
    ...

Please let me know if that makes sense. If not, I will explain much better

!

06-15-2009, 04:17 PM	#2 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	You can use the `AS` keyword for that. sql Code: SELECT myTable1.id AS myTable1_Id, myTable2.id AS myTable2_Id FROM ... Please let me know if that makes sense. If not, I will explain much better ! __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.