i just want to show that record not existing table {tbl}mailtemp

__________________
Reputation is for time; character is for eternity.

Try something like that :

SELECT en.id, en.title, mt.id, mt.subject
FROM {tbl}noticelogs AS nl, {tbl}expiration_notice AS en
JOIN {tbl}mailtemp AS mt
ON en.type=mt.parentid
WHERE nl.noticeid<>en.id AND nl.mailid<>mt.id

Tiffany Jewellery For Sale this is certainly a compromise, people all over the world often wear a Tiffany imitation a great entire evening yet others are none the wiser.

The Tiffany name became so famous Tiffany Pendants Sale movie was made while using company's name from the title. "Breakfast at Tiffany's" featured top-name actors and indicated how well-known the corporation had become 100 years after its inception. Today, when a lot of people think of the name "Tiffany UK Sale's" the picture of exquisite jewelry drifts into their minds. Totally the fine gold and platinum items through the company studio and it's hardly surprising that a person might ask, "Can it be Tiffany?