Posted by alex on 03/17/06 20:38

Thanks for the response. Let me pose the example this way:

I'm attempting to write a query against a table (Table_A). Let's
say the table has three columns with various records. Column_1 lists
the names of vehicle manufacturers. I have a preexisting list that
I'm attempting to bounce of my table. I want, however, all of the
names in my preexisting list to appear in my results. If the criterion
doesn't exit, it should say 'NULL'. Thanks for any help.

For example:

Table_A

COLUMN_1 COLUMN_2 COLUMN_3
Ford Blue 4door
Chevy Blk 2door
Honda Blue 4door
Nissan Red 2door

My preexisting list looks like this:

Ford
Chevy
Honda
Nissan
Toyota
Jeep

I want to select every record from COLUMN_2 and _3 that = Blue and
4door.
I want my results to look like this:

Vehicle_Make Column_2 Column_3
Ford Blue 4door
Chevy null null
Honda Blue 4door
Nissan null null
Toyota null null
Jeep null null

[Back to original message]