> In English please. My sentiments exactly :)
But... "easier than it already is" Anyway, you have your way and everyone else has theirs. If the way you are using is making it more difficult for you than it needs to be and can be simplified, then by all means simplify it. And I will most definitely have to disagree that adding a unique identifier to allow the table to stand on its own without the relations is hardly more complicated. > this is by far the easiest way to link tables. No... Its the only way to "link" tables that's why we do it. But he didnt ask for data from multiple tables or how to link them, he asked for data from one table... the one without unique identifiers. It seems that you are becoming a little uptight about this (of course I could be wrong, it's hard to read tone) but please dont take any of this as an attack on your methods or a defense of my own. I've read a lot of your posts and solutions and have nothing but respect for you... I just respectfully disagree here. Nothing more. If your not getting uptight... I'll drop it here anyway because... well... pro-longed exposure to me tends to make people that way :) -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Saturday, May 21, 2005 6:27 PM To: CF-Talk Subject: Re: SQL Query Question Ewok wrote: > I guess that痴 one way of looking at it... I think creating the need to > combine them is more work than its worth or would ever need to be. Valid or > invalid, I still recommend something a little more easier to differentiate > records with such as a single unique key per record. I think adding an extra field solely for a unique identifier only complicates the matter. Especially in many to many relations this is by far the easiest way to link tables. Though I suppose that if you really needed to you could always define a composite type. > After all, what hes having trouble with would be "less trouble than it' > already not" if they existed here. In English please. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:207360 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54