SQL Language (MOSC)

MOSC Banner

Need help in one SQL Query

edited Aug 16, 2010 5:19AM in SQL Language (MOSC) 10 commentsAnswered ✓
 Hi All,  
I have two tables as follows:

Table: MST
========
Id             Strt        Cnt            Nm
---            ------        -----         -----------------------------------------
1              101         100           X
1              310           90           Y
1              450          260          X
2              951            50          A
2             1050          160          Y

Table: LOCATOR
=============

Id            Strt          Cnt
---          -------         ------
1            151             40
1            251            500
2            959            100



I want to select rows from Table MST based on the rows from table LOCATOR. The joning columns are self explained
 
 
Any one can help ?
 
 
 
Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center