How to get the matching columns from a table for each row in another table?
This is a discussion on How to get the matching columns from a table for each row in another table? within the Pgsql Performance forums, part of the PostgreSQL category; --> Hi all.. I have two tables such as cisco and ciscocom. and i wan to compare each row of ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 08:13 AM
| ||||
| ||||
 How to get the matching columns from a table for each row in another table? Hi all.. I have two tables such as cisco and ciscocom. and i wan to compare each row of ciscocom with cisco having same column values. i wan to get the count of matching columns for each row in cisco... eg: Ciscocom has columns: Products,fw,ports,sec,des,tput etc and cisco has columns:fw,ports,sec,des,tput etc. i wan the number of matching colum for each row in ciscocom. please provide me with the procedure.... Waiting for your response....      |
Linear Mode
