link / merge tables

[vantuch]

I'm a newbie -- I have 2 tables:

TABLE1 has the majority of the data, several fields.

TABLE2 has just two fields, one of which corresponds to a field in TABLE1, 2nd field is an empty field in TABLE1 but needs the data from TABLE2

all records in TABLE1 do not exist in TABLE2
all records in TABLE2 do exist in TABLE1

-- is there some way to do this?

 

[PHV]

A Starting point:
SELECT * FROM TABLE1 LEFT JOIN TABLE2 ON TABLE1.SomeField = TABLE2.Field1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[vantuch]

is that a query?

 

[vantuch]

I'm not at all sure what to do with the information you've given me.