Re: How get record?.

["Amm85" <webforumsuser@xxxxxxxxxxxxxx>]

I split query and tried this....not working...

 <cfquery name="tbl_emp q" datasource="#dsn#" username="#user#" 
password="#pass#">
 select id,tbl_emp.name,st_date
 from tbl_emp 
 where tbl_emp.status = 'retired'
 </cfquery>


 <cfquery name="tbl_dept_q" datasource="#dsn#" username="#user#" 
password="#pass#">
 select id,deptname
 from tbl_dept
 </cfquery>

 <cfquery name="tbl_emp_dept_q" dbtype="query">
 select tbl_emp.id,tbl_emp.name,tbl_emp.st_date,tbl_dept.deptname
 from tbl_emp left join tbl_dept
 on tbl_emp.id = tbl_dept
 </cfquery>