COnverting Ints from other tables

[sharvey99]

Can anyone help as I'm a bit of an SQL duffer...

I have a table 'table1' that contains 2 fields

type int,
summary varchar(255)

Values

'21' 'This is an SNMP Trap'

Each value for type has a text conversion in 'table2'

type_text varchar(16),
type_int int

'SNMPTrap' '21'

Is there a method of displaying the Int value in table1 using the text equiv. from table2 during a sinlge select
statement?

In short I would like to see...

type: summary:
'SNMPTrap' 'This is an SNMP Trap event'

when I do a query instead of

type: Summary:
'21' 'This is an SNMP Trap event'

I hope this is clear
Many Thanks in advance

 

[tlbroadbent]

A JOIN query like the following should give what you need.

Select b.Type_Text, a.Summary
From table1 As a
Job table2 As b
On a.Type=b.Type_int Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[sharvey99]

Thanks alot

That worked a treat !