wonderwizard Posted May 14, 2013 Share Posted May 14, 2013 Hi, It was long time since a wrote some asp, and are a little bit off. I have 1 access database, with 2 tables, bikes and brand and column make are in both, I want to loop the result of column modell in bikes, IF column make are the same in both bikes and brand. can some please help me Link to comment Share on other sites More sharing options...
justsomeguy Posted May 14, 2013 Share Posted May 14, 2013 It sounds like you want a join: SELECT a.make, a.model FROM bikes AS a INNER JOIN brand AS b ON a.make=b.make Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now