> > SELECT ct.* > FROM tbl_clients cl > INNER JOIN tbl_clientConsultants cc ON cc.clientId = cl.clientId > INNER JOIN tbl_consultants ct ON ct.consultantId = cc.consultantId > Where cl.active = 1 >
Woops, that's slightly out, that will get all consultants that are assigned to active clients - but hopefully you get the jist and will be able to mold that to your needs. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303389 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
