New to propel and im hitting a wall when trying to write a query.
I've tried the joinWith for an explicit join but my output isnt displaying correctly.
SQL:
SELECT Appointments.*, Agent.*, Clients.*
FROM Appointments
INNER JOIN Agent ON Appointments.AgentID = Agent.AgentID
INNER JOIN Clients ON Appointments.ClientID = Clients.ClientID
Propel:
$appointments = AppointmentsQuery::create()
->joinWith('Appointments.Agent')
->joinWith('Appointments.Clients')
->find();
echo $appointments;
I would like to return an object that has each individual appointment with the agent and client details associated with the appointment so i can then pull the values from the object. Instead it seems as though appointment information is repeating and my object isnt being created correctly.