|
|
Posted by MC on 11/15/05 18:10
Uhh, you will not get distinct rows with this query. You're missing the
'distinct' in the select part..
MC
"Mike" <noway@forgetit.com> wrote in message
news:9wnef.172$4o7.80@newssvr24.news.prodigy.net...
>I figured it out. I am idiot today.
>
> I used the following:
> SELECT T1.* FROM T1, T2 WHERE T1.C1 = T2.C1
>
> Thanks,
> Mike
>
> "MC" <marko_culo#@#yahoo#.#com#> wrote in message
> news:dlcuce$eaj$1@magcargo.vodatel.hr...
>> Something like this?
>>
>> select distinct gd.GLCODE, gd.GLDESC
>> from
>> GL_CODE_DESC gd
>> inner join GL_SVC_CODES gs on gd.GLCODES = gs.GLCODES
>>
>> I dont really understand the req about GLCODES being equal but this
>> should help you out....
>> MC
>>
>>
>> "Mike" <noway@forgetit.com> wrote in message
>> news:GUmef.4$rq3.0@newssvr19.news.prodigy.com...
>>>I have the following tables:
>>>
>>> Table Name: GL_CODE_DESC
>>> Field Names: GLCODE, GLDESC
>>>
>>> Table Name: GL_SVC_CODES
>>> Field Names: GLCODE, SVCCODE
>>>
>>> What I would like is a query that pulls the distinct rows from the table
>>> GL_CODE_DESC but only where the GLCODES are equal between the two
>>> tables.
>>>
>>> How would I do this?
>>>
>>> Thanks in advance!!
>>>
>>> Mike
>>>
>>
>>
>
>
Navigation:
[Reply to this message]
|