Home » SQL & PL/SQL » SQL & PL/SQL » Joining tables??? (Oracle 10g)
Joining tables??? [message #294140] Wed, 16 January 2008 10:39 Go to next message
newbie22
Messages: 3
Registered: January 2008
Junior Member
Hi,

I am trying to join two tables and get the result as below

Table1
ID
100
200
300

Table2
Group_ID---ID
1----------100
1----------101
1----------102
2----------200
2----------201


I have the query below so far and it gives me 100, 101, & 102 which is okay. But I want to get rid of 100 which is the matching id between table1 and table2. How to do that?
SELECT T2_2.ID FROM
TABLE1 T2_1
JOIN TABLE1 T1
ON
 T1.ID=T2_1.ID
JOIN TABLE2 T2_2
    ON T2_1.GROUP_ID=T2_2.GROUP_ID;


Thanks!
Re: Joining tables??? [message #294146 is a reply to message #294140] Wed, 16 January 2008 10:48 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Explain with words what is the result you want, that is the rule to go from the input to the output.

You can also format the table content.
You can also post the result of the query.

As you are a newbie, post your questions in newbie forum.

Regards
Michel
Previous Topic: insert sequence with value from other table
Next Topic: query execution life cycle
Goto Forum:
  


Current Time: Fri Dec 09 23:22:37 CST 2016

Total time taken to generate the page: 0.06236 seconds