i want ot retrive the data like

[php4om]

i created two tables like this

table 1 Template

Field Type Attributes Null Default Extra Action
id int(11) No auto_increment

memid int(11) Yes NULL

tempname varchar(250) Yes NULL

templatename varchar(250) Yes NULL

proname varchar(250) Yes NULL

tourname varchar(250) Yes NULL

flag tinyint(1) No 0

n_status tinyint(4) No 1

dirname varchar(200) No

table 2 member

Field Type Attributes Null Default Extra Action
id int(11) No auto_increment

Name varchar(250) Yes NULL

n_last_name varchar(255) No

n_gender varchar(255) No

Address varchar(250) Yes NULL

City varchar(250) Yes NULL

State varchar(250) Yes NULL

Country varchar(250) Yes NULL

Username varchar(250) Yes NULL

Password varchar(250) Yes NULL

type varchar(20) Yes 0

Company varchar(50) Yes NULL

n_phone_area int(11) No 0

i want ot retrive the data like
the value id in table member is not present in the table template memid.

the query i used is like this

SELECT m1.id, m1.Username
FROM member m1
JOIN template t1
WHERE m1.n_status =1
AND m1.id <> t1.memid
ORDER BY m1.id ASC
LIMIT 0 , 30

but i am getting every value present in table member.

thanks advance

[tsinka]

Hi,

try

SELECT m1.id, m1.Username
FROM member m1
LEFT JOIN template t1
ON m1.id = t1.memid
WHERE m1.n_status =1
AND t1.memid IS NULL
ORDER BY m1.id ASC
LIMIT 0 , 30