Demo entry 1067569

Test code

   

Submitted by anonymous on Jan 13, 2015 at 20:05
Language: Coldfusion CFC. Code size: 268 Bytes.

<cfquery name="test" datasource="#MainDSN#">
	SELECT
		t1.col1 AS 'column1',
		t1.col2 AS 'column2',
		t2.col3 AS 'column3'
	FROM table1 t1
	INNER JOIN table2 t2 ON t1.iTable1Id = t2.iTable1Id
	WHERE
		t1.col1 != 'fooBar'
		AND t2.col1 != 'fooBar'
</cfquery>

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).