Search results for query: *

The SQL in the solutions given to my query will fetch all the rows or all the distinct rows in the two tables. My problem was to obtain the rows which are NOT COMMON between the tables. e.g. There are two tables say emp and emp1 having columns eno, ename The rows in emp : 1 emp1 2 emp2 3...

There are two tables with identical structures. I want a single query (TSQL) to obtain the rows which are not common between the tables. Please note that the difference may be in any column. i.e. in set theory notation I want (Tab1-Tab2)U(Tab2-Tab1) Please help !!

thanks for the quick response, i tried it but it doesnt work, it doesnt ask me anything about the button or anything like that.

I have created a form and it has a subform on it. I want the form to have a button which when clicked will display the record on sub form for the respective record on the main form. Is that possible to do ? how ?

There r many clients, clients can be of 3 types - prospect, business, trust. one client can belong to one or more types at the same time. accordingly i designed tables like this: client('clientID', firstname, surname) prospect('clientID', b'date,taxcode,income) business('clientID'...