jkkenzie Posted February 18, 2012 Share Posted February 18, 2012 The code below is not giving me records in tbl_business with ONLY more than 1 related records in tbl_activities SELECT tbl_activities.act_code, tbl_business.bid, tbl_business.appformno, tbl_activities.appformno FROM tbl_business INNER JOIN tbl_activities ON tbl_business.appformno = tbl_activities.appformno HAVING tbl_activities.appformno >1 LIMIT 50 Link to comment https://forums.phpfreaks.com/topic/257239-select-fields-from-linked-table-with-more-than-one-foreign-key/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.