Query Question
This is a discussion on Query Question within the SQL Server forums, part of the Microsoft SQL Server category; --> I have the following tables: Table Name: GL_CODE_DESC Field Names: GLCODE, GLDESC Table Name: GL_SVC_CODES Field Names: GLCODE, SVCCODE ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 02:55 PM
| ||||
| ||||
 Query Question 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      |
|
02-29-2008, 02:55 PM
| |||
| |||
| Re: Query Question 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 > |
|
02-29-2008, 02:55 PM
| |||
| |||
| Re: Query Question 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 >> > > |
|
02-29-2008, 02:55 PM
| ||||
| ||||
| Re: Query Question 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 >>> >> >> > > |
Linear Mode
