joining unique table alias

[jschlee]

I want to join one table two times:

situation:

table one:

name1 -> join -> table 1
name2 -> join -> table 1

the query that I have build (and does not work) :

SELECT apps_table . , con_table .
FROM apps_table
LEFT JOIN con_table
on apps_table.PilotTCID = con_table.ConId
LEFT JOIN con_table
on apps_table.PilotFCID = con_table.ConId
LIMIT 0, 30

[the_Igel]

Isn't that clear, what do you want. Maybe this will help:

SELECT *
FROM apps_table as a
LEFT JOIN con_table as b on a.PilotTCID = b.ConId
LEFT JOIN con_table as c on a.PilotFCID = c.ConId
LIMIT 0, 30

[jschlee]

Thankx that worked!

but how do I user the data in my script?

I mean the the tables were joined, but how do I define the diference between these table?

the con_table contains the column con_name

but how do I use this in my script?

$row->con_name...this works but how do I print the other contact?

[the_Igel]

SELECT b.con_name as con1, c.con_name as con2, .....

Hope you don't need ALL columns 🙂

[jschlee]

thnkx!

the result:

SELECT a.*,
AliasContact_1.CFName as contact_table1,
AliasContact_2.CFName as contact_table2
FROM apps_table as a
LEFT JOIN con_table as AliasContact_1 on a.PilotTCID = AliasContact_1.ConId
LEFT JOIN con_table as AliasContact_2 on a.PilotFCID = AliasContact_2.ConId