| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Mark Steudel | Date: | June 29 2006 9:15pm |
| Subject: | Distinct from two tables | ||
| View as plain text | |||
Is there a way get distinct results between pf and sf? Select pf.name, sf.name From tblpropertyfeatures, tblsuitefeatures Inner Join tblfeatures AS pf ON tblpropertyfeatures.featureid = pf.id Inner Join tblfeatures AS sf ON tblsuitefeatures.featureid = sf.id ----------------------------------------- Mark Steudel NetRiver Web and Application Developer 555 Dayton St. Suite A Edmonds, WA 98020 w: http://www.netriver.net p: 425.741.7014
| Thread | ||
|---|---|---|
| • Distinct from two tables | Mark Steudel | 29 Jun |
| • Re: Distinct from two tables | Peter Brawley | 29 Jun |
