--- nitya bansal <[EMAIL PROTECTED]> wrote:
> hello to all
> is there a way i can compare data between tables in
> MYSQL? say
> i have two TABLES 'A' and 'B'
> TABLE A has
> COL1
> COL2
> COL3
> TABLE B has
> COL1
> COL2
> COL3
>
> Now i want to compare that is there any difference
> between data of col1 in
> both tables n if there is difference then return the
> field which is not
> present in col1 of table A.
its a matter of using join inteligently.
regards
VK
PS: such questions are more suitable at ilugd-dev
mailing list.
I have studied in an university called life!!!!
Disclaimer
The facts expressed here belong to everybody, the opinions to me. The
distinction is yours to draw...
__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail
_______________________________________________
ilugd mailinglist -- [email protected]
http://frodo.hserus.net/mailman/listinfo/ilugd
Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi
http://www.mail-archive.com/[email protected]/
