Two Inner Joins

[Andrew K.]

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?

[aspnetguy]

something like this

SELECT *FROM table1 INNER JOIN table2 ON table1.column1 = table2.column2INNER JOIN table 3 ON table2.column2 = table3.column3WHERE blah = blah

[Andrew K.]

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?

[aspnetguy]

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.