for this sent table is used. Once all members gets mail, prod_flag will be set to 1
table structure
product
product_id
product_name
prod_flag
member
member_id
member_name
sent
product_id
member_id
I am trying to get all those member_ids and products whose flag=0 and not in sent table.
Code: Select all
"SELECT * FROM members, product WHERE AND member_id NOT IN sent"how to get product ids which are not in sent table.