how to use group by in mulity table query?
Posted on 2004-08-31
I have two table that named table_user and table_area,
in table_user there some user records:
in table_area stores areacodes and their areaname
I want to make an query return back records like that:
which format sql phras that I would use?
I use that text and sql anlays can't pass though grammar check:
select "table_user".username, "table_area".areaname,"table_user".sex from "table_user","table_area","table_user" group by "table_user".areacode;
sure i don't think it can work.
the help files with oracle 9i have only few graphic,no more info....
thanks you read this question post by a poorman poor in english