Mysql table merge question

BR
BR used Ask the Experts™
on
Dear Experts,
I need to select user ids which are in table 1 but not avaliable in table2 ? how can I do that?
how can I select the uid value which appears in table 1 but not table2 ?

Table 1
SELECT uid FROM satisci_tablosu

Table 2
SELECT distinct uid as satisci FROM takip WHERE tarih >= '$raportarihi' AND tarih < date_add( '$raportarihi' , interval 1 day)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Guru
Most Valuable Expert 2011
Commented:
SELECT uid FROM satisci_tablosu
WHERE uid not in (
  SELECT uid FROM takip 
  WHERE tarih >= '$raportarihi' 
     AND tarih < date_add( '$raportarihi' , interval 1 day)  
)

Open in new window

BRDigital Marketing

Author

Commented:
Thank you bery much

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial