This topic is locked
[SOLVED]

 subquery to get name and phone

4/5/2010 8:03:47 PM
PHPRunner General questions
M
mdorren author

I have created an agent table for the real estate template where the agentid (primary key) is also in the main home listing. I'd like to show the agent name as well as phone number in the main home list. I feel that I would have to use an event before the list display to get the extra fields and assign them to variables that I can put in the list. Is there a tutorial to be able to do this sort of thing?
Thanks

K
Khris 4/5/2010

On the "Edit SQL Query" screen, Select your Main Home List on the left hand side. Add in your Agent Table, and then create a Left Outer Join between the two using your AgentID. Add in the additional fields from the Agent table that you want to display on the Main Home List.

M
mdorren author 4/5/2010



On the "Edit SQL Query" screen, Select your Main Home List on the left hand side. Add in your Agent Table, and then create a Left Outer Join between the two using your AgentID. Add in the additional fields from the Agent table that you want to display on the Main Home List.



Thanks, I'll give it a try

M
mdorren author 4/7/2010



Thanks, I'll give it a try



Worked like a charm! Thanks Khris!

K
Khris 4/7/2010