Dear All

I have 2 SQL tables called STOCK and STOCKDESCS.

The common field is STOCKID.

In the STOCK table I have all of the rows that I have posted, but my
STOCKDESCS table is short of the same rows.

Do you know of a quick query I could use that basically lists the following

(table STOCK) (table STOCKDESCS)
(field STOCKID) (field STOCKID)
IVP IVP
STP STP
JVC2 JVC2
TOSH4 <blank and therefore a missing row>
MJB MJB
V566 <blank and therefore a missing row>
KBG KBG
etc.... etc....

Many thanks for any help you can give.

Rgds

Robbie