Distinct values

[smartaju420]

Hello Friends,

I have two tables like following

Table Name: Company
Company_Entry_I D Company
---------------------------- -------------
<CPY0000001> <Fusion>
<CPY0000002> <MTN>
<CPY0000003> <XPC>

Table Name: Support_Groups
Support_Organiz ation Support_Group Company
------------------------------- --------------------- --------------
<InternalSupport> <ITSupport> <XPC>
<InternalSupport> <EmployeeSupport> <XPC>
<HelpDesk> <ITSupport> <Fusion
<InternalSupport> <CustomerSupport> <Fusion

Now I want the results like following in a separate view

Support_Organiz ation Support_Group Company Company_Entry_I D
------------------------------ --------------------- ------------- ---------------------------
<InternalSupport > <ITSupport> <Fusion> <CPY0000001>
<InternalSupport> <EmployeeSupp> <XPC> <CPY0000003>
<InternalSupport> <CustomerSupp> <Fusion> <CPY0000003>
<HelpDesk> <ITSupport> <Fusion> <CPY0000001>

So in this case what should be the query...

I am asking this b'coz i never worked on Database like this...and frankly I don't know too much about database. I know only select, update, drop etc...

Plz help me, I'll be highly grateful to you people

Thanks in advance

[deepuv04]

Hello Friends,

I have two tables like following

Table Name: Company
Company_Entry_I D Company
---------------------------- -------------
<CPY0000001> <Fusion>
<CPY0000002> <MTN>
<CPY0000003> <XPC>

Table Name: Support_Groups
Support_Organiz ation Support_Group Company
------------------------------- --------------------- --------------
<InternalSupport> <ITSupport> <XPC>
<InternalSupport> <EmployeeSupport> <XPC>
<HelpDesk> <ITSupport> <Fusion
<InternalSupport> <CustomerSupport> <Fusion

Now I want the results like following in a separate view

Support_Organiz ation Support_Group Company Company_Entry_I D
------------------------------ --------------------- ------------- ---------------------------
<InternalSupport > <ITSupport> <Fusion> <CPY0000001>
<InternalSupport> <EmployeeSupp> <XPC> <CPY0000003>
<InternalSupport> <CustomerSupp> <Fusion> <CPY0000003>
<HelpDesk> <ITSupport> <Fusion> <CPY0000001>

So in this case what should be the query...

I am asking this b'coz i never worked on Database like this...and frankly I don't know too much about database. I know only select, update, drop etc...

Plz help me, I'll be highly grateful to you people

Thanks in advance

[code=sql]
SELECT s.Support_Organ ization,s. Support_Group,s . Company ,c.Company_Entr y_ID
FROM Support_Groups AS S INNER JOIN
Company AS C ON C.Company = s.Company
order by s.Support_Organ ization
[/code]