Posted by Mike on 11/15/05 17:53

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
>>
>
>

[Back to original message]