I'm trying to inner join these first two tables but the query is blank when executed

CREATE TABLE Borrowers  (    TRN int primary key,  schools varchar (3),  FN varchar (15) ,  LN varchar (16),  Gen varchar,  Email varchar (30),  street# varchar (4),  streetName varchar (25),  parish varchar (13)  );    create table AgentLoans  (  LID varchar,  DateOfLoan Date,   TRN int,  Agent_ID varchar (4),  FN varchar (15) ,  LN varchar (16),  CONSTRAINT fk_AgentLoans_Loan FOREIGN KEY (LID) REFERENCES  LOAN(LID),   CONSTRAINT fk_AgentLoans_borrowers FOREIGN KEY (TRN) REFERENCES Borrowers(TRN),  CONSTRAINT fk_Agents_AgentLoans FOREIGN KEY (Agent_ID) REFERENCES  Agents(Agent_ID)    );      SELECT B.FN, B.LN,B.Gen,U.LID,U.DateOfLoan  FROM Borrowers as b INNER JOIN AgentLoans as u  ON b.TRN = u.TRN;  

https://stackoverflow.com/questions/66609673/im-trying-to-inner-join-these-first-two-tables-but-the-query-is-blank-when-exec March 13, 2021 at 10:50AM