For the mysql experts...

[richie]

Without having to go into the details of the table structures, please see if you can find anything glaringly wrong with the query below.

The query gives me this error:

Column 'id' in field list is ambiguous,

but I don't see any ambiguity there.

select count(0) from employerInfo i
left outer join employerJobfairs e on i.id=e.id
left outer join jobfairEvents v on e.jobFair=v.id
where i.id!='' && cityOfInterest='FL'
&& i.id in (select id from employerJobfairs where repName!='')
&& i.id in ( select id from employerJobfairs e,jobfairEvents j where j.jobfairDate>=now() && e.jobFair=j.id )

I'm using Mysql 4.1.9

Thanks.

[richie]

I found the problem. Here is the correct query:

select count(0) from employerInfo i
left outer join employerJobfairs e on i.id=e.id
left outer join jobfairEvents v on e.jobFair=v.id
where i.id!='' && cityOfInterest='FL'
&& i.id in (select id from employerJobfairs where repName!='')
&& i.id in ( select e.id from employerJobfairs e,jobfairEvents j where j.jobfairDate>=now() && e.jobFair=j.id )