Shamsul Kamal
asked on
How to create mysql NOT EXISTS statement ?
Hi,
I would like to request an assistant.
I have the following mysql table and column :
Table clientid
==========
column 1 : no
column 2 : name
column 3 : domain
Table list
==========
column 1 : no
column 2 : status
column 3 : domain
May i know how to do mysql query to list the domain that is not exist in the other column "domain" above ?
eg of data :
clientid.domain
============
abc1.com
abc2.com
abc3.com
list.domain
=========
xyz1.com
xyz2.com
abc1.com
Appreciates any assistant.
I would like to request an assistant.
I have the following mysql table and column :
Table clientid
==========
column 1 : no
column 2 : name
column 3 : domain
Table list
==========
column 1 : no
column 2 : status
column 3 : domain
May i know how to do mysql query to list the domain that is not exist in the other column "domain" above ?
eg of data :
clientid.domain
============
abc1.com
abc2.com
abc3.com
list.domain
=========
xyz1.com
xyz2.com
abc1.com
Appreciates any assistant.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you give the expected result from your eg .data ?