Sure can. This query Select * from typelookup WHERE (TypeIDFK = 1 AND Type IN (3,4)) OR (TypeIDFK = 2 AND Type IN (1,5)) OR (TypeIDFK = 3 AND Type IN (3,4)) OR (TypeIDFK = 4 AND Type IN (1,4)) OR (TypeIDFK = 5 AND Type IN (3,4))
returns TypeIDFK Type PotteryIDFK ----------- ---------- -------------------- 4 1 3 2 1 3 2 1 4 5 3 5 2 1 5 1 4 6 2 1 6 3 4 6 4 1 6 5 4 6 5 3 6 3 4 7 2 1 7 2 1 8 2 1 9 this is just the first few rows. YOu can see PotteryID 6 Let me know if I can provide any more info. That's what I figured about needing a one or more subqueries, just not sure how to set something like that up. Thanks! On 12/26/05, Ian Skinner <[EMAIL PROTECTED]> wrote: > > I think this would be a lot easier if you had separate join tables for > each type of join, but I will try and get my head around how this might work > with your universal join table. Can you provide a small representative > example of the data you get if you use the 'OR' version of the WHERE > clause. I will need to set up an example for myself to test ideas. > > I suspect you are correct in that this will most likely require an > interesting sub query or two. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227691 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
