| select/group by problems [message #132688] |
Mon, 15 August 2005 12:53  |
reach_honey
Messages: 10
Registered: June 2005
Location: Boston
|
Junior Member |
|
|
I have situation where I have written this big query to solve the problem.
The query is like
Select table3.x,table5.y,count(table1.z)
from table1,table2,table3,table4,table5
where
table1.id=table2_id(=) and
table1.2nd_id=table3_id and
table1.3rd_id=table4.id and
table1.current_date=table5.id
group by 1,2
I created above joins between in Business area as administrator.
Now i'm not using all fields in select statement.But when i try to create a sheet if i select only 2 fields then i can add all the folders in my current sheet.
And if i select 1 field from table in order to fulfill this join. I get other fields coming up in Select statement.
Which i not what i want?
How should i complete this.
Thanks in advance for your help.
|
|
|
|
| Re: select/group by problems [message #132796 is a reply to message #132688] |
Tue, 16 August 2005 04:47  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Select the items you need, plus the required ones to "point out the joins" (so, one item from each of the 5 folders needed), run the report and delete all items you don't need.
Regards,
Sabine
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
