tlid mbno name gender tl1 123 yes m
id tlid rfid 1 tl1 12 2 tl1 3 tl1
rfid type abc xyz tlid 12 one a.. x.. tl1
tlid id name gender type abc xyz tl1 1 yes m one a.. x.. tl1 2 yes m tl1 3 yes m
tlid id name gender type abc xyz tl1 1 yes m one a.. x.. tl1 1 yes m tl1 2 yes m tl1 3 yes m
SELECT a.tlid, a.id, b.name, b.gender, c.type, c.abc, c.xyz FROM table1 a JOIN [table] b ON a.tlid = b.tlid LEFT JOIN table2 c ON a.rfid = c.rfid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)