I want to find a wholesum resultset, limited to 25 records, in the following way:
- Users from Table1 based on a condition
- And those Users should not be in Table2 [Non restricted users]
- Join those records to Table3 on Table1.Group_id = Table3.Group_MEMBER_ID where Table3.GroupName = 'someValue'
- Join Table1 with Table4 on Table1.UserName = Table4.UserName
Am currently using two queries and am using UNION. Something like this:
( SELECT Table_4.DeviceName from Table1 left join Table2 on Table1.UserName = Table2.UserName inner join Table4 on Table1.UserName = Table4.UserName where Table1.some_column = 'someValue' and Table2.UserName = null limit 25 ) UNION ( SELECT Table4.DeviceName from Table1 inner join on Table1.Group_ID = Table3.GROUP_MEMBER_ID inner join Table4 Table1.UserName = Table4.UserName where Table3.GroupName='someValue' and Table1.some_column = 'someValue' limit 25 );
The point is, I cant limit the wholesum resultset to 25 records. I should use LIMIT to each query. Is there a way to merge it into a single query so that I can limit the wholesum resultset to 25?
Note: PL/SQL and CTE not available in my Development System and hence am not able to use it.