This is another joint query relative to the general Inner Joint Query; keyword: ( ) eg where a.cardid = B.CardId ( ), where "( )" writes in less information; For example, there is a record of the card in the TableCard table, and there is an authorization record with an authorized card in Tableentitle; this is not an authorized card with a general Inner Joint Query: where a.cardid = B.cardid. Information and if using Out Joint Query: where a.cardid = b.cardid ( ) Select A.CardId, A.CardSeires, B.ProductId, B.Expiredate from TableCard A, Tablentite B Where A.CardId = B.CardId ) Order by cardid; This can display the solvent record, no matter whether this card has an authorized record;
