TalkPHP - View Single Post - Need some help with SQL Join... Cant seem to come up witha working solution

Wildhoney · 11-13-2008, 02:16 AM

Is this just a case of adding unique names? Such as like in the following example:

sql Code:

SELECT
    myTable1.myColumn1 AS MyCol1,
    myTable2.myColumn1 AS MyCol2
FROM
    myTable1
INNER JOIN
    ...

11-13-2008, 02:16 AM	#2 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	Is this just a case of adding unique names? Such as like in the following example: sql Code: SELECT myTable1.myColumn1 AS MyCol1, myTable2.myColumn1 AS MyCol2 FROM myTable1 INNER JOIN ... __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.