Here is what I've got:

Table1 has the following 2 fields:
PCODE (C) 15
PDESC (C) 35
* This is a table of valid codes and procedure descriptions

Table2 has the following 2 fields:
PCODE (C) 15
PALIAS (C) 15
* This is a table of Alias's that the procedures may also be known as.

I need to create a query/view that combines the two of them
into one. In other words if Table1 has the following entry:

CODE DESCRIPTION
==========================
P200 REMOVE PART

and table2 has the following entries:

CODE ALIAS
==========================
P200 PART REMOVAL
P200 REMOVAL OF PART

I need to get a result set that returns:

P200 REMOVE PART
P200 PART REMOVAL
P200 REMOVAL OF PART

I'm sure there is a way, I'm just not sure what it is yet. Any help greatly appreciated.

Kirk
kkelly@cqisol.com