Re: [SQL] comparing 2 tables

2005-03-15 Thread Richard Huxton
U K Laxmi wrote: Thank you for the reply. Sorry for posting this problem here. Thought SQL syntax for Ms Access and PostgreSQL are similar. So, i posted here. My problem is: I've original version of a table called PMM (Product Material Master). Thro' a web interface, user can change that table co

Re: [SQL] comparing 2 tables

2005-03-15 Thread U K Laxmi
Thank you for the reply. Sorry for posting this problem here. Thought SQL syntax for Ms Access and PostgreSQL are similar. So, i posted here. My problem is: I've original version of a table called PMM (Product Material Master). Thro' a web interface, user can change that table contents. Once cha

Re: [SQL] comparing 2 tables

2005-03-15 Thread Richard Huxton
U K Laxmi wrote: I've two Ms Access tables with the same structure. This is a PostgreSQL list - you'd probably be better using a Microsoft-Access list. [snip] Here what we should observe is, 1st row in table 1 not present in table2. 2nd row in table1 is modified in table2. 3rd row in table 2 is n

[SQL] comparing 2 tables

2005-03-15 Thread U K Laxmi
I've two Ms Access tables with the same structure. Tablestructure is as follows: Table table1 SbPartNo char(50) PartDesc char(200) manPartNo char(200) manufacturer char(100) vendor char(100) refDesi char(200) qty char(5) My requirement is as follows: table 1 partDesc1 11 xyz1 vendor1