Copy link to clipboard
Copied
quote:
<cfquery datasource="sourcename" name="queryname">
select 1,2
from tablename
where 2=<cfoutput>'#otherqueryname.3#'</cfoutput>
</cfquery>
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
quote:
Originally posted by: Dan Bracuk
Are you familiar with this syntax?
select field1, field2, etc
from table1 t1 join table2 t2 on t1.somefield = t2.somefield.
where etc
Copy link to clipboard
Copied
quote:
Originally posted by: aidencamichel
Not one bit familiar.
I gave it a go anyway, but only got errors. But that's because I don't know how to use that syntax :(
Copy link to clipboard
Copied
Copy link to clipboard
Copied