已知3个表:
Communications表(CommunicationsId,SerialId,BaudId);
Serial表(SerialId,SerialName);
Baud表(BaudId,BaudName);
现在知道Communications表中的(SerialId,BaudId)值,查询Baud表中的BaudName和Serial表中的SerialName;
sql5 = "Select Serial.SerialName,Baud.BaudName from (Communications inner join Serial on Communications.SerialId=Serial.SerialId) inner join Baudon on Communications.BaudId=Baud.BaudId";