Coldfusion if statement help

See more:

database

How can I show a table row if a sub-task exists?

Database info:
- table1 tasks table
- table2 sub-task table

Some tasks have sub-tasks, so how do I create an if statement for the results table: if tasks table has a record in the sub-tasks table display the record below the task record.

<td> #taskName# <td>
<cfif subtask exists display row>
   <tr>
	  <td>#sub-taskName#</td>
   <tr>
</cfif>

What I have tried:

<cfif taskID = sub-taskid>
<pre> <tr>
	  <td>#sub-taskName#</td>
   <tr>
</cfif>