I have the following query setup:
Code: Select all
$listSql=("SELECT * FROM sctblAttendee
LEFT JOIN itvtblRegistrations ON itvtblAttendee.intAttendeeId=itvtblRegistrations.intAttendeeId
WHERE strAttendanceOption='na'");
$listRes=mysql_query($listSql);The field in the table is defined as varchar.
Any ideas?