There is a set of pictures (1-4), the first audit information is placed in the primary table A, all of the picture details are placed in the table B, the Objid of each set of pictures is the same. Now query all unidentified picture information.
You need to query chKFLG = 0 in a table, query all image details of Objid and A in the B table.
Select A.ID, B. * Form Zubiao A, Congbiao B Where A.chkflg = 0 and B.Objid = A.ID
