New help with a join statement

[spertuit]

So I have a left join

		"SELECT * FROM `dailyMasterLogs` AS logs LEFT JOIN `vessels` AS vessel ON ( logs.logVesselID = vessel.vesselName) ORDER BY $field $order"

This works, but I need to add in a where clause on the logVesselID. I want to select all from the dailymasterlogs where logvesselid = foo as logs, but thats not working. Any help on this?

 

[Barand]

       

SELECT * 
FROM `dailyMasterLogs` AS logs 
LEFT JOIN `vessels` AS vessel ON logs.logVesselID = vessel.vesselName
WHERE logs.logVesselID = foo
ORDER BY $field $order

[spertuit]

Thanks a million, I thought I had tried this, but must have missed it somehow. I appreciate the help!