I have a simple master-detail setup. Some rows in the master don't have corresponding detail. I need to get a result dataset which will contain a distinct result set containing all records from the master(whether they have detail or not), but with some kind of calculated field indicating which of those records have detail and which not. The reason I need this is to display a list of all members, and at the same time indicate(via a colour) all members in my app which don't have detail. Oh, by the way I am looking for the SQL.
Thanks a lot,