我有三张table
Table1 : ID, Description
Table2 : ID, FirstName, LastName
Table3 : FirstName, LastName, Flag
我想用一个链接到第三个表的条件左联接table1和table2。
Result Table: ID, Description, FullName (FirstName + LastName)
(Condition: only the names that have flag set to true in table3 can be used in the resultant table)
如何完成以下任务?先谢谢你。
1条答案
按热度按时间m528fe3b1#