Join table problem

[snowboardr]

I am not doing something right i know, the join I am doing here works fine however I would like to still show the bid even if the project doesn't exist..

	sqlBid= "SELECT ibid,ipid,icompany, iaddress, icity, istate, izip, iemail, iname, iphone, idateexp, idate, ilicence, iwork, iliability," _
	& "pro.pid, pro.ptitle"_
	& " FROM ibids, project as pro WHERE ibids.ibid=" & queryBid & " AND pro.pid=ibids.ipid"

Thanks,

Jason

 

[TonyGroves]

You would need to use an outer join, such as:
[tt]
FROM ibids LEFT JOIN project pro ON pro.pid=ibids.ipid
WHERE ...
[/tt]
That way the fields from any non-existent project records will be null.