Help! with Parameter Query for complex SQL
Is there a way to use Parameter Query which contains SQL statement that
contains multiple select statement within the SQl statement? For example, <Case 1 select a.name, b.dept_name, c.salary from employee a, dept b, hr c where a.emp_id = b.emp_id and b.band = c.band and c.salary 39999 = THis will work with Parameter Query since it only contains one select statement <Caase 2 select a.name, b.detp_name, c.salary from employee a, dept b, ( select * from hr where salary 39999 ) c where a.emp_id = b.emp_id and b.band = c.band = THis will not work with Parameter Query since it contains sub select statement Please let me know how I can use Parameter Query for case 2. Thanks |
All times are GMT +1. The time now is 04:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com