Andrew K. Posted January 10, 2007 Share Posted January 10, 2007 How would I go about using two INNER JOINS in a SQL query? I've tried this by going INNER JOIN table2, table 2 ON blah = blah , blah = blah as well as INNER JOIN table2 ON blah = blah INNER JOIN table3 ON blah = blahBut neither work, could someone help me out please? Link to comment Share on other sites More sharing options...
aspnetguy Posted January 10, 2007 Share Posted January 10, 2007 something like this SELECT *FROM table1 INNER JOIN table2 ON table1.column1 = table2.column2INNER JOIN table 3 ON table2.column2 = table3.column3WHERE blah = blah Link to comment Share on other sites More sharing options...
Andrew K. Posted January 10, 2007 Author Share Posted January 10, 2007 Unfortunately that doesn't work. I just learned a few hours ago that Coldfusion doesn't support two joins :'(Is there another way I could go about doing this? Link to comment Share on other sites More sharing options...
aspnetguy Posted January 10, 2007 Share Posted January 10, 2007 That is odd that Coldfusion would limit the fuincionality of SQL because the query I gave you is valid SQL and I use it a lot.Perhaps Skemcin can answer this since he is the CF expert. 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