|
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
Navigation:
[Reply to this message]
|