Anybody? Bueller? Bueller?


<a> wrote in message news:TfWdnWlQENNvhr_ZnZ2dnUVZ_uudnZ2d@comcast.com. ..
>I have 3 tables, one main table, and two tables that reference the first
>table. the two reference tables may have more than one entry to the first
>one. I am able to use left joins to see all the data for the three tables,
>however, for a specific purpose, i only want to see the first instance of
>the 2 joined tables. Is there a way to do SELECT DISTINCT, but only have
>it distinct on the columns from the first table, or do a subquery to get
>the other two tables, using LIMIT 1. I'm using mysql 3.26. If this limits
>me in any way, let me know what i can do w/ 4.1 or 5.0. thank you.
>