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)
TOSH4 <blank and therefore a missing row>
V566 <blank and therefore a missing row>
Many thanks for any help you can give.