| Re: COMPLEX SQL QUERY - HELP REQUIRED [message #375171] |
Thu, 02 August 2001 02:53 |
Mohan Rajgopal
Messages: 1
Registered: August 2001
|
Junior Member |
|
|
You can write the same query in this method also. actualy this will be faster than the previous reply query.
select quote_id, section_id, long_name from quote_section_xref a, roof_system b
where b.roof_system_id = a.roof_system_id
and quote_id in
(select distinct quote_id from quote_section_xref c, roof_system d
where c.roof_system_id = d.roof_system_id and
d.roof_system_type = 1)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
