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 tablesMark Steudel29 Jun
  • Re: Distinct from two tablesPeter Brawley29 Jun